Sign
 
Purpose 
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 
FileMaker Pro 6.0 or earlier
Examples 
Sign(15.12) returns 1.
Sign(-175) returns -1.
Sign(BalanceDue) returns 0, if BalanceDue is a number field containing 0.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.