ROOT( ) function

Returns the square root of a numeric expression.

Syntax

ROOT(number, decimals)

Parameters

number

Numeric. The numeric expression to find the square root of.

decimals

Numeric constant. The number of decimals to use in the output.

Output

Numeric.

Remarks

This function returns the square root of the numeric expression or field value with the specified number of decimal places. The result is rounded appropriately. This function returns zero if the number parameter is a negative number. You can use the LOG( ) function to perform other root functions, such as cube root.

Examples

Example Return value

ROOT(100, 2)

10.00

ROOT(1000, 4)

31.6228

Related reference
LOG( ) function


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback