Sign
Description
Returns the sign of a number, either positive or negative or zero.
Calculation Editor
Options
| Input Parameter Values | Input Values |
|---|---|
| Only Rollup If | Generic Criteria |
Input
| Input | Input Values | Required |
|---|---|---|
| Input 1 | Column or Literal | ✔ |
Remarks
Output options include 1, 0, -1 to indicate positive, zero or negative sign.
Example
- Input: -250
- Quick Calculations > Math > Sign
- Output: -1