Generating rows based on amount left over

[VidyaS]

Hello,

I am trying to build a workflow in Alteryx that could help with distributing the payment amounts to different accounts based on the payments and balances.

I have attached a spreadsheet with an example of what I am trying to achieve.

[Qiu · Accepted solution]

@VidyaS 
Not completed understand the bussiness math here.

Hope this is what you need.