Current row - previous row calculation

[hegdepavithra10]

Hi,

I have a column with some numerical data in it. I want to create a column which would have the value current row -previous row of the given column. I tried to Multi row formula, but i was not able to add the expression.

Could you please assist 

[echuong1 · Accepted solution]

You are correct in that it would be a multi-row! See attached.

[Emil_Kos · Accepted solution]

Hi @hegdepavithra10,

Multi row formula was the one the correct formula for this task:

Output:

If this is something helpful please mark as solved!

[hegdepavithra10]

@echuong1 Thank you . This worked. One more query. If i have multiple fields as such to be created, should i use multiple "Multi Row formula"?

[echuong1]

Yes, exactly. There will be a multi-row formula per column created/updated. 

It is unlike the Formula tool in that you can only handle one column at a time, versus the Formula tool you can consolidate.

[Emil_Kos]

Hi @hegdepavithra10,

Thank you for marking my post as an answer!

How many columns like this will you need to create?

[gouravbibhor2020]

I need this for Multiple column