SQRT
The square root function (SQRT) returns a square root of a number (e.g., Revenue). If the number is negative, SQRT returns NULL.
Syntax
SELECT SQRT(…)
SELECT SQRT(constant)
SELECT SQRT(metric)
Examples
SELECT SQRT(25)
returns the value "5" SELECT SQRT(33.6)
returns the value "5.796550698" SELECT SQRT(SELECT SUM(Sales))
returns the square root of a Total Sales metric
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.