Calculate the rollover qty backwards

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.

Datasets

Developer

Data Investigation

Accepted answers

I've changed the logic ever so slightly here by updating the first Join to include your Unique Key:

For Ronal2.yxzp

All comments

@Ronal_bal How is it that the expected output for the first record is 4409? Where did that come from?

@Prometheus becuase the current status is ahead, so row+1:Expected Output -received qty. which is 4410-1 = 4409.

Sorry by next cum i mean next expected output.

Can you help me with this request? @Prometheus

@Ronal_bal Is the column Expected Output the actual expected output for each row or is it a part of the dataset?

@Prometheus it is the expected output. Not a part of the dataset.

Like so:

For Ronal2.yxzp

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703