SQRT( ) Calculates the square root of a number. Syntax SQRT(num) Argument num The number, or numeric expression specifying the number, for which you want to find the square root. The number must be a positive number. Returns A number that is the square root of num. Example The following example calculates the square root of each value in the LotSize data field: SQRT([LotSize]) The following example uses SQRT( ) to calculate the actual distance travelled uphill, given the base distance and elevation values. This example applies the Pythagoras theorem, which states that . Using this theorem, the actual distance travelled is c, which means we want to calculate which translates to the following expression: SQRT((([Distance] * [Distance]) + ([Elevation] * [Elevation])))
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy