Converting cumulative data to incremental

Question

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!

Sample Dataset.xlsx

binu_acs · Answer

@peterg97 similar to other solutions

Cumulative_20_05.yxmd

messi007 · Answer

@peterg97,

Please see below :

Attached the workflow,

Regards,

Cumulative_20220520.yxmd

IraWatt · Answer

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

Multi Row 2005.yxmd