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
