Average Macro Allocation - Weighted

[Preeki]

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".

From	To	% allocation
1	2	50%
1	3	50%
2	4	30%
2	5	70%
4	6	60%
4	7	40%
7	1	100%
6	8	100%

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

[Reinierk · Accepted solution]

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]

Awesome thanks!!