Skip to Content
Former Member
Jul 03, 2007 at 06:34 AM

Forumula - different values when drilldown


I am running a report on Plant , where I have Sales value , Sales Qty and Stock Qty as Keye figures. I created one formula for Stock value

= Stock qty * ( Sales value / Sales qty ) . I defined "Calculate results as " - summation.

When I run this report for a plant , I get Stock value as 50.10 and when I drilldown by Material then I get the Overall result for Stock value as 39.24 .

39.24 is correct because it is sum of stock value for all materials in a plant . 50.10 is calculating along the columns. How do I acheive this?

I tried - created a Calculated KF , Before aggregtion , cumulate along the rows and formula collision - from this formula , but every time I get 50.10 only.

Pls advice

Message was edited by: