SQRT( )

Calculates the square root of a number.

Syntax

SQRT(number)

Argument

number

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 the specified number.

Examples

The following example calculates the square root of each numeric value in the LotSize 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 Pythagorean theorem, which states that . Using this theorem, the actual distance traveled is c, which means we want to calculate

which translates to the following expression:

SQRT((([Distance] * [Distance]) + ([Elevation] * [Elevation])))

Copyright Actuate Corporation 2012