Count and reallocation

[Preet2020]

Hi,

In the table below, I need to redistribute the sum of count of KL094 & Q1124 equally to other SystemID's.

KL094 = 5 & Q1124 = 25. Total = 30.

This 30 needs to be equally redistributed to other SystemID's so eventually the count of KL094 & Q1124 should become zero and the Grand Total stays 140

How can i get this done in Alteryx workflow?

SystemID	Count of SystemID
ED4465	20
ED4466	10
FN563	30
FN564	50
KL094	5
Q1124	25
Grand Total	140

[Verakso · Accepted solution]

You haven't really described the rules for your even distribution

If you take the 30 divide it with the remaining four systems, you end up with 7.5, so is it okay to have ½ systems?

Because in that case, this seems to work

[bhrmitra]

Hi Preet2020,

Please find the below output. I hope this will answer your question.

If this solves your issue please mark the answer as correct and also hit the like button, if not let me know! I've attached my workflow for you to download if needed.

Thanks,

Abhra Mitra

[Preet2020]

Hi, Attachment is missing