how to skip first row in multi row formula

Sshasnk

I have a dataset and I want to skip the first row and subtract the one which is above

Example:

value

12

13

23

56

Output:

value	new value
12	12
13	1
23	10
56	33

So skip the first row and put the value which is in the value column, for the rest of the row subtract the value above ex 13 -12 = 1 and 56-23 = 33

Emil_Kos

Hi @Sshasnk,

This is the multirow formula that you should try:

IF !isnull([Row-1:value]) THEN [value]-[Row-1:value]ELSE [value] ENDIF

I have created a workflow for you:

In order to make it work I needed to remember to keep this option:

Multi Row Skip.yxmd