Skip to Content

Calculate Cumulative Quantity in BEX with two logics.

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 25, 2017 at 09:28 AM

    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

    Add comment
    10|10000 characters needed characters exceeded