Amount and Days Difference

Vapour02

Hi all professionals, I need help to get a desired output about amounts and days differences. So I have Account, Debit amount and Credit amount. I need the days difference between two Debit amounts and sub-total value of Credit amount lying between two Debit amounts. Also remaining amount of Debit amounts minus the sub-total value of Credit amount. Also the first line wherever there is Debit amount should not be considered and the output should be calculated from next line and there can be missing dates which should be considered as it is as they are actually missing. The calculation should start again as the account changes. Hope I'm able to explain as much as I can. Attached is the sample for reference. Kindly help with a desired solution. Thank you.

Amount _Days_Diff_Sample_Alteryx.xlsx

aatalai

I would use the multi row 

formula to caluate sum of debit with running total

[running total debit (newly created field):row-1]+debit

grouping by account ID

and then do something with credit.

Then use a regular formula tool to do the difference of the 2 running totals. You could go fancy with this codnitonal formula

If debit !=0 then running toatl credit - running total debit else NULL() endif.

@Vapour02 let me know if this helps