Error: Parenthesis expected after function name

[krueger]

Sup with it, 

I am currently trying to add a Formula to my schedule with an if-statement.

Ive got:

"Loggia" (a yes/no parameter)

"Area" (the normal Revit Parameter which displays the area of a room)

"Fictional Room" (the column where I want to display the result of my formula)

Why: I want to display the actual area of a room divided by 2 if I uncheck the yes/no parameter ("Loggia") in the "Fictional Room" column.

My if-statement currently is:

• if(Loggia=NOT, Fictional Room=Area/2, Fictional Room=Area/1)

Revit however states "Parenthesis expected after function name" which I thought I already covered with the parenthesis following "Area/1".

Anyone got an idea how I can make this Formula work in my schedule?

Im using Autodesk Revit 2018

[ToanDN]

Try:  

if(not(Loggia), Fictional Room=Area/2, Fictional Room=Area/1))

[barthbradley · Accepted solution]

If Fictional Room is the Parameter you are applying a formula to, you don't use it's name in the formula. The result of the test is either Area/1 or Area/2. 

so...if (not(Loggia), Area/2, Area/1)  

...also, I get this error when I have a "-" in the parameter name that I want to use in another parameter's formula (e.g. "Height-Arm"). The remedy is the put the name in brackets in the formula (e.g. "[Height-Arm]"). 

[ToanDN]

@barthbradley

You are correct.  The [Fictional Room] needs not be in the equation.

[barthbradley]

@krueger: you'll love this link: 

https://www.revitforum.org/tutorials-tips-tricks/1046-revit-formulas-everyday-usage.html