Hello experts,
I have three key figures ($ Net Price - KF from Cube, Sales Qty - CKF, & $ Total Open Sales - Formula) in my report calculated at the material level. there are other characteristics in this report apart from material....the Totals match when the material is present in the report, but as soon as the material is removed from the report, the totals of Open sales go wrong. Let me give you a prototype of what i am talking about:
[code]Sales Doc # | Material ID | Price ($) | Sales Qty | Total Sales
1 A - 120 -
1 B $ 20 20 $ 400
___________________________________________________________________________________________
Total 140 $ 400[/code]
But if we remove the Material ID drill down, then the scenario is as follows:
[code]Sales Doc # | Price ($) | Sales Qty | Total Sales
1 $ 5 140 $ 700[/code]
Now the price and total sales is calculated wrong.....Over here, $ 5 * 140 = $ 700 is calculated. but, that's not the right calculation....my main concern is the total sales....what do i do to make the total sales = $ 400?[code][/code][code][/code]