Running total for limited volume and priority

Hi Alteryx Community Team,

I have a priorization of deliveries which I need now to split in buckets. Our outbound can only handle 4'000 units so I would need to allocate as much as I can per day on the priority. Is there an option to allocate first all the "Priority 1" deliveries up to 4000 units and after the "Priority 2"?

Is there also a way if "Priority 1" reaches like 3500 units but the next "Priority 1" will give me over 4000 units so I check if there is an "Priority 2" which maybe fits in to reach 4000 units?

Hope you understand my questions 🙂

In attached is an example of a data set.

Thank you very much,

Pascal

example.xlsx

Datasets

Accepted answers

mceleavey

Hi @Pascal_R ,

this requires a bit of multi-row magic.

I've attached the workflow, but it basically looks at the priorities as groups, then assigns the number to each one in order until the 4000 limit is reached. It then calculates how much was allocated to each row.

I hope this helps.

Multi-Row Magic.yxmd

All comments

mceleavey

Hi @Pascal_R ,

this requires a bit of multi-row magic.

I hope this helps.

Multi-Row Magic.yxmd

Pascal_R

@mceleavey

Thank you very much for your fast response!

The result is already promising 🙂 What is if we cant partial the delivery like in yellow highlighted?

They grey qtys gives a total of 3162 meaning we could allocate another 838 units. Is it possile to tell Alteryx searching for others first priorities, in the case also those are to big than its checking the first priorities?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703