ROOT( ) function
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.