New FOCUS Functions

Two FOCUS functions, COALESCE and NULLIF, are now available in calculators in the Data Management Console.

COALESCE evaluates the arguments in order and returns the first argument that is not MISSING. NULLIF returns a missing value when its parameters are equal. If they are not equal, it returns the first value.