Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
We have a Requirement & Stock Table as given below,
ReqTable StockTable
Material | Reqmt | Material | Stock | |
1 | 10 | 1 | 30 | |
1 | 5 | 2 | 10 | |
1 | 20 | 3 | 10 | |
2 | 10 | 4 | 0 | |
2 | 4 | 5 | 20 | |
3 | 10 | |||
4 | 10 | |||
5 | 10 |
We want to achieve results as given below-
Required Results :-
Material | Reqmt | Cummulative Requirement | AvailableStock |
1 | 10 | 10 | 30 |
1 | 5 | 15 | 20 |
1 | 20 | 35 | 5 |
2 | 10 | 10 | 10 |
2 | 4 | 14 | 0 |
3 | 10 | 10 | 10 |
4 | 10 | 10 | 0 |
5 | 10 | 10 | 20 |
Tried hard but unable to find out the way.
Please help us with your expertise.
Thanks,
Girish.
see attachment
see attachment
Hi Girish,
Please see attached. I actually got some help from Massimo on this.
Cheers!
Dear Massimo,
Thanks for quick reply, Issue is resolved.
You were correct the in 3'rd Row of AvailableStock the value should be 15.
Dear Patrick,
Thanks for further help.
Regards,
Girish.