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 ?
You cannot use a text parameter to drive a formula. Try an integer / yes no / number parameter instead.
Conditional statements can contain numeric values, numeric parameter names, and Yes/No parameters.
@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)
=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.
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.