0

Square Root and Power functions

Ernie Prabhakar

January 24, 2017 23:14

None

Follow

Since I am importing data directly from a raw source, I need to do all my processing in Klipfolio.

I didn't see a list of math operators anywhere, but I could not find any Square Root function.  

https://support.office.com/en-us/article/SQRT-function-654975c2-05c4-4831-9a24-2c65e4040fdf

Or more generally, a Power funciton.

https://support.office.com/en-US/article/POWER-function-D3F2908B-56F4-4C3F-895A-07FB519C362A

 

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Stephen Yates February 06, 2017 13:54

  Hi Ernie, we do not have a Square Root function, but we do have a Power function. Please let us know if that works for you.

• 0
  
  Ernie Prabhakar February 06, 2017 19:18

  Doh! Not sure how I missed that. Works perfectly, thanks!

• 0
  
  Mime Analytics Ltd Admin March 14, 2021 22:59

  hello 2021!
  4 years have passed!

  
  I need to do a pearson's correlation calculation
  
  all the fiddly calculations are done, but the last calculation which need square root function

  any idea on how I can achieve this?

  or a workaround maybe?

   

  thank you

• 0
  
  Parker Selman March 17, 2021 18:46

  Hi! 
  
  You can use a POWER function to return the square root of a number, where the 'exponent' provided = 0.5 . 
  
  For example,
  
  POWER(64,0.5) returns a value of 8. 
  
  Hope this helps! 
  
  Parker