Please help: Parse error at char (89):Unmatched(
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Datasets
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have included + sign to perform the multi row function. I am not getting results as expected. Kindly guide me on this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 :)
