Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Am I proud of it? No. Does it work? Yes. Should I try again with the macro approach? Probably...
Pretty straight-forward this time (and I did a lot better than I did with the last warehouse problem faced)
Spoiler
Process:
- Join Store and Required data
- Sort results by Item then by Priority
- Join with warehouse Count in stock
- 1st Multi-Row tool groups by Item and decrements Count by amount required per store (but can't go below 0)
- 2nd Multi-Row tool groups by Item and calculates the Assigned amount which will equal Required, except
-- If Count has decreased to 0, then Assigned is equal to Count of the prior row
- Clean-up data
- Sort by Store then by Item (both ascending)
- Join Store and Required data
- Sort results by Item then by Priority
- Join with warehouse Count in stock
- 1st Multi-Row tool groups by Item and decrements Count by amount required per store (but can't go below 0)
- 2nd Multi-Row tool groups by Item and calculates the Assigned amount which will equal Required, except
-- If Count has decreased to 0, then Assigned is equal to Count of the prior row
- Clean-up data
- Sort by Store then by Item (both ascending)
