ROOT( ) function

Returns the square root of a numeric expression.

Syntax

ROOT(number, decimals)

Parameters

Name Type Description
number numeric

The numeric expression to find the square root of.

This function returns zero if number is a negative number.

decimals numeric The number of decimals to use in the output.

Output

Numeric.

Examples

Basic examples

Returns 10.00:

ROOT(100, 2)

Returns 31.6228:

ROOT(1000, 4)

Remarks

How it works

The ROOT( ) function returns the square root of the numeric expression or field value with the specified number of decimal places. The result is rounded appropriately.

When to use ROOT( )

Use LOG( ) to perform other root functions, such as cube root.