This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.
How can I calculate the square root using the formula builder? We have been using the 'Power' function with an exponent of .5 but the release notes mention a new square root function.
We added a square root function 'Sqrt' in the 2017.2 release which can be used rather than the Power function.
Prior to the 2017.2 release
To calculate the square root of a value using the formula assistant you need to use the ‘Power’ function. The syntax for this is:
Power (N, E)
This means that what will be returned is the value of number N raised to the power of E.