This content has been marked as final.
Show 2 replies
-
1. Re: Creating groups through IF / ELSEIF / AND formula
Chris McClellanDec 12, 2016 7:54 PM (in response to Nicola Prime)
"Null" is a string, which isn't the same as NULL (what you're seeing on the screen)
Try this :
IF ISNULL([Category]) AND [Model Name] = "DC"
THEN "Group A"
ELSE [Category]
END
Basically you have to use ISNULL to see if [Category] has a NULL value or not.
-
2. Re: Creating groups through IF / ELSEIF / AND formula
Nicola Prime Dec 15, 2016 10:35 PM (in response to Chris McClellan)Works perfectly Chris, thanks for your help!