You are viewing our older product's guide. Click here for the documentation of GoodData Cloud, our latest and most advanced product.
ABS
The absolute value function (ABS) returns an absolute value of a number (e.g., Revenue) as a positive number:
- positive inputs will remain unchanged
- negative inputs will be rendered positive
Syntax
SELECT ABS(…)
SELECT ABS(number)
SELECT ABS(metric)
Examples
SELECT ABS(-5) returns the value "5"
SELECT ABS(10) returns the value "10"
SELECT ABS((Total_Amount)-(SELECT Total_Amount WITHOUT PF))