Null value

grace · 2022-04-06T14:43:52+00:00

There was an error rendering this rich post.

Very basic question here, trying to create a calculated column returning "TRUE" if another column has a value and false if not - neither of these are working. I assume my language is not correct here?

Thanks

case when `Intro Call Held Date (Cleaned)`= value then true else false end

case when `Intro Call Held Date (Cleaned)`= null then false else true end

Find more posts tagged with

Accepted answers

GrantSmith

CASE WHEN `Intro Call Held Date (Cleaned)` IS NULL THEN FALSE ELSE TRUE END

Null is a special value and requires the IS comparator instead of = when checking to see if a value is null or not.

grace

Thanks Grant! That worked :)

All comments

GrantSmith

CASE WHEN `Intro Call Held Date (Cleaned)` IS NULL THEN FALSE ELSE TRUE END

Null is a special value and requires the IS comparator instead of = when checking to see if a value is null or not.

grace

Thanks Grant! That worked :)

GrantSmith

@grace Great! I'm glad it worked for you. If you could accept my answer as a solution so others could find it more easily I'd appreciate it.