Hi @Ekmi9 ,
Ok, I built an iterative macro to do this for you, and I get the same figures as you until one row. I cannot get the numbers to reconcile and the only thing I can think of is you've typed on number incorrectly, or you have provided the incorrect logic.
These are the figures I get applying the logic you have proided:
As you can see, my calculated figures on row 15 show a balance of 16925859.33 where yours shows 1692589.33. It looks like you've missed the second 5, or I've missed something huge.
Let me know if that's a mistake on your part or not.
Thanks,
M.
@Ekmi9 ,
I built this as an iterative macro, and it's probably going to be a bit complicated to go over the entire thing, but the logic is as follows:
the data is first split into types, subs and redemptions, the first of which is take from each one. Then, the redemption amount is taken from the sub amount giving a balance, and adjusting the amount on the sub down to that balance. The redemption is then given the balance and is fed out. The sub then iterates around with it's remaining balance and the next redemption is applied. This is repeated until the balance of the sub drops to zero, at which point it is fed out with it's initial amount and the next sub is taken for the remaining redemptions.
And so on until all are done.
I've attached this as an extraction so it will install the macro for you.
I hope this helps,
M.
I have version issue for cleansing macro
@Ekmi9 ,
I would also recommend looking into Iterative Macros more. You can find resources at the following links:
https://help.alteryx.com/20221/designer/iterative-macro
https://community.alteryx.com/t5/Interactive-Lessons/Creating-an-Iterative-Macro/ta-p/657925
Hope this helps.
M.
Ok, that may be a problem, but try the following.
I've attached the workflow and the macro. Copy the .yxmc file to your macro folder, then open the workflow. I have amended the XML in the file to be version 2021.1 but I recommend upgrading your version soon.
M
