Progress
Report Builder
User’s Guide


SQRT

Returns the square root (as a numeric value) of a specified expression.

SYNTAX

SQRT ( expression ) 

expression

A numeric expression (a constant, field name, or expression that results in a numeric value). If the value of the expression is negative, SQRT returns the unknown value (?).

EXAMPLE

To print the square root of the contents of the numeric field Numbers, create a calculated field containing this expression:

SQRT(Numbers) 

Sample data:

Numbers    SQRT(Numbers)
    9         3
   64         8
 1024        32 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095