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))
Was this information helpful?
Thank you for your feedback!
Thank you for your feedback!
If you can't find what you need, don't hesitate to send us a comment.
Any questions?
Check out the GoodData community.