Sign
Returns -1 when a number is negative, 0 when zero, 1 when positive.
Format
Sign ( number )
Parameters
number - any numeric expression or field containing a numeric expression
Data type returned
number
Originated in version
6.0 or earlier
Example 1
Sign(15.12) returns 1.
Sign(-175) returns -1.
Sign(BalanceDue) returns 0, if BalanceDue is a number field containing 0.