Skip to Content
0
Former Member
May 04, 2005 at 05:57 AM

Aggregation of Calculated Key figures

33 Views

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