Multirow Formula Fail? Reads 0 instead of Value?

[ChrisSpr]

So I want to see the change in value of a same cell month by month.

Really I wanna get a % change but for testing purposes I'm doing a difference.

It's like it reads [Row-1:Value] as 0 constantly instead of the number above.

[AbhilashR · Accepted solution]

Hi @ChrisSpr, uncheck the RecordID field in the GroupBy selection and it should work. 

[ChrisSpr]

hah.  I thought it was needed to keep it in order.  Guess not 🙂

Thanks!

[AbhilashR]

I would think of using the Group By option in cases where you want to reset row-by-row calculation for sections of data, for e.g. calculation for the eastern region should be treated separately than western etc. Also, the multi-row formula tool on its own does not affect the order of records.