You are viewing our older product's guide. Click here for the documentation of GoodData Cloud, our latest and most advanced product.
SIGN
The signum (SIGN) function returns a number or metric input as one of the following three values:
- -1 if the number is negative
- 0 if the number is zero
- 1 if the number is positive
The SIGN function follows the rule:
SIGN(number_input) = (number_input)/(abs(number_input))
Syntax
SELECT SIGN(…)
SELECT SIGN(number)
SELECT SIGN(metric)
Examples
SELECT SIGN(-3) returns the value -1
SELECT SIGN(3) returns the value 1
SELECT SIGN(0) returns the value 0