ROOT() returns the square root of a positive numeric expression or field value. You must specify the number of decimal places in the result.
ROOT(N,#)
• | # is a numeric constant representing decimal places that cannot change from record to record. |
ROOT() returns the square root of a positive numeric expression or field value N with # decimal places. The result is rounded appropriately. This function returns zero for negative values of N. For performing other root functions (such as cube root), see LOGARITHM().
Note: If the ROOT() function is used to determine the square root of a negative numeric expression or field value, Analyzer always returns a zero value.
ROOT(100,2) = 10.00
ROOT(1000,4) = 31.6228