Error
@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.
Hi @Ekmi9 ,
Can you please provide the data, not just a screen image.
Thanks,
PFA
Interesting scenario.
You can achieve your solution by using Multi Row Formula tool for this operation. I am sharing the workflow. Hope this works for you.
Thanks!!
@grazitti_sapna
If you are using full data then it is not working as expected i required FIFO logic when i can minuses Redemption till first sub is not zero and then use the next sub. for next Redemption
Thanks
this doesn't make sense, or your numbers are wrong.
Can you explain the balance on row 15?
Do you have time to jump on a call as that doesn't make sense either.
The first sub, last redemption, K4+K16...none of that makes sense.
I'm happy to jump on a call and go over the logic and see if I can help you out. DM me if you would like to jump on a Teams call.
Ok, I think I got it.
I have version issue for cleansing macro
