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?

POWER

Returns the given numeric value raised to the power of the second argument.

Returned Type

This function returns a number.

Syntax and Details

POWER(numeric_expression,power)

Where:

Example

The first example shows the %COUNT measure raised to the third power:

SELECT POWER(MEASURES.[%COUNT],3) ON 0 FROM patients
 
                                     POWER
                          1,000,000,000,000

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

SELECT %LABEL(POWER(MEASURES.[%COUNT],3),"PAT CNT^3") ON 0 FROM patients
 
                                 PAT CNT^3
                          1,000,000,000,000

The following example shows a fractional power:

SELECT POWER(MEASURES.[%COUNT],0.5) ON 0 FROM patients
 
                                     POWER
                                        100

See Also

Feedback