How to calculated a remaining quantity per part number? For each part number in our warehouse we have a "start quantity" and for each product we have a forecast date where we will remove a "quantity used". We had to calculated the "remaining quantity".

See example below:

I tried with {FIXED Part number: SUM(Start quantity + Quantity used)} ==> Problem with the second line, because you don't have the right value of "remaining quantity" but the "start quantity".

I tried with Max(start quantity)+(Sum(quantity used)+previous value(0)) ==> Problem with the second part number, he is using the "quantity used" from the previous part number.

I tried with WINDOW_SUM(SUM([[Mbstqt]]+[Motrqt]]]),-1,0) ==> Problem with the second part number, he continue to used the "remaining value" from other part number.

Many thanks in advance for you help!

Regards

Anne-Claire