This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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],[Column2]+"-"+[row+1:Column2])))
Many thanks for you help!
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.
@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!!!