Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have available stock of 16 for Item 'A'.
But req. is 26.
Now i want to allocate that 16 to the oldest deadline IDs.
In this case, i want to allocate available 16 to the IDs till deadline 7/22 as they are close by- since it counts to 15.
ID | Deadline | ITEM | Req. | Avail. |
1 | 7/10/2017 | A | 1.00 | 16.00 |
2 | 7/12/2017 | A | 1.00 | 16.00 |
3 | 7/15/2017 | A | 1.00 | 16.00 |
4 | 7/15/2017 | A | 1.00 | 16.00 |
5 | 7/15/2017 | A | 1.00 | 16.00 |
6 | 7/18/2017 | A | 1.00 | 16.00 |
7 | 7/18/2017 | A | 1.00 | 16.00 |
8 | 7/18/2017 | A | 1.00 | 16.00 |
9 | 7/19/2017 | A | 1.00 | 16.00 |
10 | 7/19/2017 | A | 1.00 | 16.00 |
11 | 7/20/2017 | A | 1.00 | 16.00 |
12 | 7/21/2017 | A | 1.00 | 16.00 |
13 | 7/21/2017 | A | 1.00 | 16.00 |
14 | 7/21/2017 | A | 1.00 | 16.00 |
15 | 7/22/2017 | A | 1.00 | 16.00 |
16 | 7/24/2017 | A | 2.00 | 16.00 |
17 | 7/24/2017 | A | 2.00 | 16.00 |
18 | 7/24/2017 | A | 1.00 | 16.00 |
19 | 7/24/2017 | A | 1.00 | 16.00 |
20 | 7/25/2017 | A | 2.00 | 16.00 |
21 | 7/25/2017 | A | 1.00 | 16.00 |
22 | 7/25/2017 | A | 1.00 | 16.00 |
23 | 7/26/2017 | A | 2.00 | 16.00 |
24 | 7/28/2017 | A | 1.00 | 16.00 |
25 | 7/29/2017 | A | 1.00 | 16.00 |
26 | 8/2/2017 | A | 1.00 | 16.00 |
Any help is highly appreciated!!
Please see the attachment
Trying the second condition brother!
Let me try.
I think so... and that is why I started with ITEM and then Deadline. Not sure if you need to sort by ID when Deadline is the same?
Thanks a lot brother!