Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section

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
Copy code to clipboard

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
Copy code to clipboard

The following example shows a fractional power:

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

See Also