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

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


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.


  • Was this article helpful?