Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Number functions > Sign function |
|
|
| Sign function |
| Format |
Sign(number) |
| Parameter |
| number - any numeric expression or field containing a numeric expression |
| Data type returned |
| number |
| Description |
| Returns one of three possible values: -1 when number is negative, 0 when it's zero, and 1 when it's positive. |
| 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 |
|
|
| Contents > Functions reference (alphabetical list) > Number functions > Sign function |
|
|
Next Page |
|