Comparing Product Demand and Date Availability Tables
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
I have two tables, one for product demand, and one with product availability dates - how would I pull the date at which point a product will have a greater quantity available than demand, adding it to the Demand table? Thanks!
Demand
Product | Demand Quantity | Running Total Demand |
A | 15 | 15 |
A | 25 | 40 |
A | 14 | 54 |
A | 16 | 70 |
A | 18 | 88 |
A | 32 | 120 |
A | 10 | 130 |
B | 18 | 18 |
B | 20 | 38 |
B | 22 | 60 |
B | 35 | 95 |
B | 70 | 165 |
B | 15 | 180 |
B | 30 | 210 |
C | 30 | 30 |
C | 14 | 44 |
C | 28 | 72 |
C | 34 | 106 |
C | 33 | 139 |
C | 21 | 160 |
C | 35 | 195 |
Availability
Product | Available Quantity | Running Total Available Quantity | Date Available |
A | 33 | 33 | 11/17/2021 |
A | 15 | 48 | 11/24/2021 |
A | 30 | 78 | 12/1/2021 |
A | 23 | 101 | 12/8/2021 |
A | 21 | 122 | 12/15/2021 |
A | 19 | 141 | 12/22/2021 |
A | 20 | 161 | 12/29/2021 |
A | 28 | 189 | 1/5/2022 |
B | 16 | 16 | 11/17/2021 |
B | 17 | 33 | 11/24/2021 |
B | 14 | 47 | 12/1/2021 |
B | 30 | 77 | 12/8/2021 |
B | 39 | 116 | 12/15/2021 |
B | 36 | 152 | 12/22/2021 |
B | 22 | 174 | 12/29/2021 |
C | 25 | 25 | 11/17/2021 |
C | 23 | 48 | 11/24/2021 |
C | 30 | 78 | 12/1/2021 |
C | 39 | 117 | 12/8/2021 |
C | 30 | 147 | 12/15/2021 |
C | 14 | 161 | 12/22/2021 |
C | 31 | 192 | 12/29/2021 |
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is it based on Running Total demand? I think you would have to join the data based on product, then compare the demands and look up the date value.
I mocked up a draft, let me know what you think. This assumes it will look up the first date when there is enough availability. There is also 3 lines where the running total demand is higher than the availability. You could add those again using union tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Great, thanks! @afv2688 & @pingu. AFV's solution worked best for my scenario, appreciate both of your input