sign
Returns an indicator of the sign of "numeric_expression": +1 if "numeric_expression" is positive, 0 if zero, or -1 if negative.
Syntax
sign ( numeric_expression )Example
sign ( [Revenue] )Result
Returns + for positive values and - for negative values.