Peek Help with script

[markgraham123]

Hello Everyone,

I'm tring to create a logic with the below sample data:

Req O/P: 'Can fill' column

ITEM	Incoming Date	Incoming_Qty	Required	Can fill
1	10/19/2017	81	126	81
1	11/1/2017	122		45
1	11/1/2017	214
1	11/9/2017	233

I have 126 units required.

i'm getting 81 on one date. So, i can fill only 81 units.

Now, the rem. quantity is 45. This can be filled with the incoming qty on 11/1/2017.

Please see attached application.

Any help is highly appreciated.