Null value

grace

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 

or

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

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

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.