Wrong formula

[yes_and_no]

Guys, I would like to get area of certain rooms reported as if "notes" is "area of work", if not then report zero. It won't work for me. Anyone ?

[ToanDN]

You cannot use a text parameter to drive a formula.  Try an integer / yes no /  number parameter instead.

[barthbradley]

Formulas can't reference text.  Numerical values or Yes/No only. 

[barthbradley]

bump.  

[yes_and_no]

I created y/n "NIC" to room property.
Then make Area of work = if(NIC="No", Area, "0"). Still not working.

[barthbradley]

Conditional statements can contain numeric values, numeric parameter names, and Yes/No parameters.

Revit Formulas for "everyday" usage - Revit Forum

[ToanDN]

---

@yes_and_no wrote:
I created y/n "NIC" to room property.
Then make Area of work = if(NIC="No", Area, "0"). Still not working.

---

Area of Work = If (NIC, Area, 0)

[barthbradley]

=if(NIC, 1,2) means if NIC is CHECKED, return 1, otherwise return 2. 

=if(not(NIC), 1,2) means if NIC is NOT CHECKED, return 1, otherwise return 2.