Difference of rows using multi row formula.

[SrinivasanSugumaran]

Hi Team,

I am trying to find the difference of. rows 1 & 2  in the last row (Delta) with multi row formula.

Name	Sales
Anton	265028.7253
Xavier	251141.7401
Delta

I am unable to see Row-2 in the multi row formula to update the formula as 

if [ Name ]="Delta" then ([Row-2:Sales]- [Row-1:Sales])

else [Sales]

endif

Am i missing something.?

Can you pls. assist.

Thanks

SS

[danilang · Accepted solution]

Hi @SrinivasanSugumaran 

Set Num Rows > 1

Dan

[SrinivasanSugumaran]

Thanks @danilang