SIGN

Returns -1 for negative values in a field, 0 for zero values and 1 for positive values.

SIGN( <field_name or value> )
  • field_name or value: The numeric field or value to perform the calculation on.

Example: create a field at the CUSTOMER level that indicate in there change in their spending patterns is positive or negative.

SIGN( [CUSTOMER.CHANGE IN VALUE] )