Alteryx designer Discussions

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

Multirow Formula Fail? Reads 0 instead of Value?

Highlighted
7 - Meteor

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

 

 

Highlighted
Alteryx Certified Partner

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

Highlighted
7 - Meteor

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

Thanks!

Highlighted
Alteryx Certified Partner

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