SAP Cloud Analytics Average Calculation

[#1]

I am using SAP cloud analytics to find the average profit by region using a calculated measure. However it does not show the average but only the sum.  I chose Average for operation and Aggregation Dimension as Region. See screenshot. The chart for Aggregation shows sum instead of average. Please advise. Thanks 

[Yogeshwar_M]

Hi @Abraham3,

Aggregation operates at the parent level, which is why it displays the same value as profit. To calculate the average, we need to consider child-level members. As shown in Screenshot 1, we first calculate the total profit, and in Screenshot 2, we determine the count of regions.

The chart illustrates the average profit region-wise.

---

Let me know if you'd like further refinements

Please upvote if the answer is correct!

Thanks.