Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

SQRT

Returns the square root of the given numeric value.

Returned Type

This function returns a number.

Syntax and Details

SQRT(numeric_expression)

Where:

Example

The first example shows the square root of the Patient Count measure:

SELECT SQRT(MEASURES.[%COUNT]) ON 0 FROM patients
 
                                      SQRT
                                        100

The next example uses the %LABEL function to apply a more detailed caption:

SELECT %LABEL(SQRT(MEASURES.[%COUNT]),"SQRT PAT CNT") ON 0 FROM patients
 
                              SQRT PAT CNT
                                        100

See Also

Feedback