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

[satya04]

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

[jonwyp · Accepted solution]

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]

@jonwyp 

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

[jonwyp]

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 :)