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

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

Datasets

Tips and Tricks

Accepted answers

jonwyp

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

All comments

jonwyp

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703