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