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

Options
Justice_RUCD
Justice_RUCD Member
edited July 7 in Calculations & Variables (Beast Mode)

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.

image.png

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

Tagged:

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    edited November 2023 Answer ✓

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

    If I solved your problem, please select "yes" above

Answers

  • ColemenWilson
    ColemenWilson Coach
    edited November 2023 Answer ✓

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

    If I solved your problem, please select "yes" above

  • Justice_RUCD
    Justice_RUCD Member

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

Categories