How to enter NULL in the calculated field formula builder?
I'd like to create a calculated field that returns NULL if the WHEN condition is not met:
In SQL, it's a simple CASE WHEN [condition] THEN [do this if condition is met] ELSE NULL
However, in the calculated field formula builder (simple option), I can't seem to enter NULL, only the string 'NULL', which would be treated differently (and incorrectly).
I've tried building the calculated field using freehand SQL (referencing a field from a subquery), but that says the field referenced does not exist.
Any help would be much appreciated.