Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

How Can I Calculate the Square Root using the Formula Editor?

This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release. 

Question

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.

Answer

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.

 

  • Was this article helpful?