Skip to Content
Former Member
Jun 26, 2013 at 04:00 PM

Calculated Key Figure Aggregating


Hi all,

I have a calculated key figure Shipped Revenue that is being Calculated as Net Price * Quantity.

When I display the report by Product Hierarchy> Sales Order> Sales Order Item > Schedule Line all calculations seems correct.

But when I just want to see the report by Product Hierarchy and remove Sales Order> Sales Order Item > Schedule Line, the revenue is aggregating because the Net Price is summing up as well.

How can I make sure that the calculations are done at a line item level even when I am running the report on the Product Hierarchy level.


Incorrect after I run it for Product Hierarchy only:



1.JPG (56.7 kB)
2.JPG (21.2 kB)