Chris Harper

NetSuite Saved Search – Comparing two different custom field values

Use a CASE statement like this:

CASE WHEN ({custrecord_field_1} != {custrecord_field_2} ) THEN 1 ELSE 0 END

Set the Formula (Text) field to is 1

Like this:

chris

,