Dear All,
I want to calculate cumulative quantity in BEX Query with 2 formulas.
1st formula applies to 1st row only. i-e: Quantity1 - Quantity2 = Result
2nd formula applies to the rest of the rows until a Sales document changes.
i-e: Result - Quantity 2.
Need your suggestions on how to achieve this logic at BEX Query designer level.
Thank you.
Hi
I guess formula 2 is just Q1-Q2 and set the caclculation as a cumul, but formula is not quite clear for me, can you let me know in the example what you want as values for formula 3
thanks