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

Workflow

Preparation

Accepted answers

Verakso

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

Count and reallocation.yxmd

All comments

Verakso

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

Count and reallocation.yxmd

bhrmitra

Hi Preet2020,

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

Untitled picture.png

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

Count and reallocation.yxmd

Preet2020

Hi, Attachment is missing

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703