Hello! In a saved search, how can I add a formula ...
# administrationm
Matt L
01/05/2023, 2:57 PMHello! In a saved search, how can I add a formula (text) version of "is not -none-"? I've tried to use NULL and != '-none-', but still returning results with '-none-'
Matt L
01/05/2023, 2:58 PMmessage has been deleted
j
JessicaL
01/05/2023, 3:31 PMdid you try "= NULL" or "IS NULL? "
JessicaL
01/05/2023, 3:31 PMIS NULL is the proper way of doing it. It sometimes acts up based on the field type but works most of the time.
m
Matt L
01/05/2023, 3:34 PMthanks for the response! Yes, I've tried is not null and !=null, but still returning -none-. actual null/blanks are being filtered out, but not -none-
j
JessicaL
01/05/2023, 3:36 PMYou can also try = ' ' (just an empty string).
JessicaL
01/05/2023, 3:38 PMor I guess !=
m
Matt L
01/05/2023, 3:38 PM😕 tried that as well.. still getting -none-
j
JessicaL
01/05/2023, 3:58 PMI'm like running through my mind palace of stuff. lol. Have you tried using NVL({field}, ' ')?
JessicaL
01/05/2023, 3:59 PMThat will return a blank in cases where a value is NULL. You can also use it for comparison like
Copy code
CASE WHEN NVL({customfield}, ' ') = ' ' THEN xxx ELSE xxx END65 Views