Calculate the rollover qty backwards

[Ronal_bal]

Hi,

I'm trying to calculate the rollover qty based on the following criteria's,

The calculation needs to start from the last record and its cum_received value. 

for the last records, use the cum_received as the expected output

Whenever the current status is delayed then use the next cum. 

whenever the current status is ahead or okay then use next_cum-current_qty

Attached the example in the excel.

[caltang]

Hmm, you're right. My current method doesn't work for single line items. Do you mind giving us more varied data? Give us more scenarios so we can account for them.