Sign Function
Description:
The sign of the number.
Returns 0 if the number is zero.
Returns 1 if the number is positive.
Return -1 if the number is negative.
Returns:
Whole Number
Parameter:
Parameter | Data Type | Description |
|---|---|---|
1 | Number | The number. |
Examples:
When using functions inside a field, remember the field brackets:
{Sign(AccountBalance)}
Expression | Result |
|---|---|
Sign( 0 ) | 0 |
Sign ( 3.5 ) | 1 |
Sign( -3 ) | -1 |