Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

Multi-Row formula tool for rows more than 1 removed from current row


Can anyone tell me why [Row+1:Column1] works but [Row+2:Column1] throws the error "Unknown Variable "Row+2:ColumnName"?

The posts I have found show that rows other than +1 and -1 should work as part of a multi row formula, but I can't get this to work.  What errors can I look for?


This is part of an IIF statement


IIF([Column1]=1, "NA",
IIF([Row+1:Column1]=1 AND [Row+2:Column1]!=1, [Column2]+"-"+[Row+2:Column2],
IIF(Row+2:Column1]=1, [Column2]+"-"+[Row+3:Column2],


Many thanks for you help!

Alteryx Certified Partner
Alteryx Certified Partner

Within the Multi-Row formula there is a configuration setting for "Num Rows".  If you increase that value, you'll be able to search against 2, 3 or more rows.





Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.

@JenM Row+2 should work so long as you've selected at least 2 rows in the "Num Rows" option:



The default is 1, so you would have to manually change it to be 2. Let me know if you've already done that and it's still throwing an error!


Brilliant - thank you! Error solved.

Can we set the number of rows field based on a parameter?

arghhhh so obvious thank you!!!