In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Please help: Parse error at char (89):Unmatched(

satya04
8 - Asteroid

I am facing parse error with unmatched on the following. Please guide me.

 

IF !Contains([Period], "2013")
THEN
([Capital_expenditures]+[Row-1:Capital_expenditures][Row-2:Capital_expenditures]+[Row-3:Capital_expenditures])
-
([Row-4:Capital_expenditures]+[Row-5:Capital_expenditures]+[Row-6:Capital_expenditures]+[Row-7:Capital_expenditures])
ELSE 0
ENDIF

 

satya04_0-1681349995462.png

 

3 REPLIES 3
jonwyp
6 - Meteoroid

Hi, are you missing a + between [Row-1:Capital_expenditures] and [Row-2:Capital_expenditures]? Apart from that don't see anything wrong in the formula

satya04
8 - Asteroid

@jonwyp 

I have included + sign to perform the multi row function. I am not getting results as expected. Kindly guide me on this.

satya04_0-1681352080576.png

 

jonwyp
6 - Meteoroid

Hi there. What results are you expecting? I believe the multi row tool will run the formula on each and every row to repeat the same calculations. Perhaps sharing a version of your workflow and expected result would help me to assist better :)

Labels
Top Solution Authors