Calculate Cumulative Quantity in BEX with two logics.

[former_member65935]

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.

[kohesco]

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