logic

[Ekmi9]

Error

[mceleavey]

Hi @Ekmi9 ,

Can you please provide the data, not just a screen image.

Thanks,

M.

[Ekmi9]

PFA

[grazitti_sapna]

Hi @Ekmi9 ,

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!!

[Ekmi9]

@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 

[mceleavey]

Hi @Ekmi9 ,

this doesn't make sense, or your numbers are wrong.

Can you explain the balance on row 15?

M.

[Ekmi9]

Error

[mceleavey]

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.

M.

[Ekmi9]

Error

[mceleavey]

Ok, I think I got it.