How do you type not equal to on the saved search, I am trying to display results for items where standard cost is not equal to location standard cost, I tried below operator but that doesn't work Difference between SQL Not Equal Operator <> and !=

CASE WHEN {field1} != {field2} THEN.... should work.

Thanks that worked, but it only shows the one with the value, I want to see the blank ones too, do I need to use a different formula? or change it?

Use NVL on the field names to set a default value when blank

that works thanks!!