Skip to Content
0

Calculate Cumulative Quantity in BEX with two logics.

Oct 25, 2017 at 08:13 AM

18

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Oct 25, 2017 at 09:28 AM
0

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


niclp.png (8.3 kB)
Share
10 |10000 characters needed characters left characters exceeded