1 of 1 people found this helpful
Difficult to say, easier if you can supply some sample data. However you can give this a go:
IF [Region] = "China" AND ISNULL(STR([Contract Number])) THEN [Region] END
I've converted Contract Number to string in case that's the issue and also removed the N/A in case it doens't like that for whatever reason. It'll return NULL instead for you to filter out.
ISNULL() will work irrespective of whether the underlying column was a string, Int, float, date, boolean.
The issue here is Region needs to be converted to a string...
Thank you both for your help - i did have [Region] as a string - i did NOT have [Contract Number] as a string =) that STR conversion command worked for me.