Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Multirow Formula Fail? Reads 0 instead of Value?

ChrisSpr
8 - Asteroid

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.

 

ChristopherS_0-1589928475742.png

ChristopherS_1-1589928489408.png

 

 

3 REPLIES 3
AbhilashR
15 - Aurora
15 - Aurora

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

ChrisSpr
8 - Asteroid

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

Thanks!

AbhilashR
15 - Aurora
15 - Aurora

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.

Labels