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

1. Input: -250
2. Quick Calculations > Math > Sign
3. Output: -1