topic Re: Wrong formula in Revit Architecture Forum

Wrong formula

yes_and_no — Mon, 25 Apr 2022 16:42:43 GMT

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 — Mon, 25 Apr 2022 16:44:27 GMT

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

barthbradley — Mon, 25 Apr 2022 16:44:59 GMT

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

barthbradley — Mon, 25 Apr 2022 16:46:09 GMT

bump.

yes_and_no — Tue, 26 Apr 2022 15:01:04 GMT

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

barthbradley — Tue, 26 Apr 2022 15:06:00 GMT

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

ToanDN — Tue, 26 Apr 2022 15:17:18 GMT

@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 — Tue, 26 Apr 2022 15:25:57 GMT

=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.