Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Average Macro Allocation - Weighted

Preeki
5 - Atom

Hi Experts,

 

I have a issue which I just can't get resolved and I hope that you can help.

 

I have a scenario where I have a table below which allocates based on a "%" between columns "From" and "To".

 

FromTo% allocation
1250%
1350%
2430%
2570%
4660%
4740%
71100%
68100%

 

The problem I have is if you look at the allocation of "2" it runs in a loop which I believe should be put in a macro, ie

2>4>6>8  end

2>4>7>1>3 end

2>4>7>1>2>4>6>8 end

etc

 

The end rule should be when the allocated % reaches an effective allocation of 99,9995% or more to then stop and allocate the balance to the highest value.

 

I have attached an example in excel which shows the above in more detail. I've also updated this post with a Alteryx workflow which does the same but it still needs to be added to a macro

 

I will really appreciate any help that you can provide.

 

Thanks

Preeki

2 REPLIES 2
Reinierk
7 - Meteor

Hi @Preeki,

 

The solution to this is an iterative macro, please see the attached workflow package with the iterative macro included.

 

Hope this helps.

 

ReinierK

Preeki
5 - Atom

Awesome thanks!!

Labels