Returns -1 when a number is negative, 0 when zero, 1 when positive.
Sign(number)number - any numeric expression or field containing a numeric expression
number
FileMaker Pro 6.0 or earlier
Sign(15.12) returns 1.
Sign(-175) returns -1.
Sign(BalanceDue) returns 0, if BalanceDue is a number field containing 0.