0
if/then/else
I have a field named "Units number", I want to create a new fx field to define the units to consider by yes and no like this:
if "Units number" > 2 then "yes" else "no" end
but the result is "no" in all cases even if the number is >2
Any help ?
6 replies
-
Use single quotes for the field names:
if 'Units number' > 2 then "yes" else "no" end
-
Not in french ! It doesn't work.
-
Is your 'Units number' field a text field?
-
No, a number
-
It works for me...
Try something else:
- Change your field name to Units_Number (without a space) and use this code:
---
if Units_Number > 2 then "yes" else "no" end
---
-
Good, it works !
Thank you, Nick !
Content aside
- 4 yrs agoLast active
- 6Replies
- 695Views