Hello ,
I have defined a Caluculated Keyfigure as
Total amount = Number of Goods * Average Price.
Records in the cube are stored at Good Level so effectively it comes to Number of records = number of Goods.
Exception aggregation for the Average price is defined as Average for (number of goods).
As a result in the query I want the total amount =
Total number of goods sold * average price .
i.e I want the aggregation of the both the keyfigures to happen before the calculation of the total price .
In the query result the multiplication doesnot match the total amount .
Please let me know if we have some settings to set the thing as aggregation before calculation .
Regards
Nikhil