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.
Message was edited by: