How do I set up multiple case statement for required field?

Justice_RUCD · 2023-11-11T00:03:25+00:00

There was an error rendering this rich post.

I'm trying to create a case statement to replace an empty field with the word 'incomplete' when the field in the previous 'required' column has a 'yes' response. When it has a 'no' response, it should be left blank. Here is a snip of the dataset.

This is what I've got so far, but I realize the 'if null' statement doesn't work this way.

CASE
WHEN
Oct '23 Required= 'yes'
AND
IFNULL(Oct '23)
THEN 'incomplete'
ELSE Oct '23
END

Find more posts tagged with

Beast Mode

Accepted answers

ColemenWilson

CASE WHEN `Oct ‘23 Required` = ‘yes’ AND `OCT ‘23` IS NULL THEN ‘Incomplete’ ELSE `Oct ‘23` END

All comments

ColemenWilson

CASE WHEN `Oct ‘23 Required` = ‘yes’ AND `OCT ‘23` IS NULL THEN ‘Incomplete’ ELSE `Oct ‘23` END

Justice_RUCD

That worked! DOMO doesn't recognize 'is null' as a function so I didn't think I could use it. Thanks for your help. 😃

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of