Converting cumulative data to incremental

[peterg97]

Hi all, 

I need to create a new column in a table that shows the incremental payments amount for each transaction. I have attached sample dataset to this post and pictures of what I would like to have. 

Before:

After:

Any help would be appreciated, thanks!

[IraWatt]

Hey @peterg97,

You just need a multi row like this:

The multi row formula groups my transaction and minus the previous transaction from the current. Please ask if any questions :)

HTH,

Ira

[messi007]

@peterg97,

Please see below :

Attached the workflow,

Regards,

[binuacs]

@peterg97 similar to other solutions