Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

POWER

Applies to: CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7

Description

The POWER function returns the value of the specified expression to the specified power.

It can be applied to INT or FLOAT columns. The resulting column is of type FLOAT.

Syntax
POWER ( table.column, exponent )
NULL handling

If one of the input values is NULL, the result is NULL as well.

Examples

[1] Calculate the power using column values as exponent.

Query

Column1

POWER ( "Table1"."Base" , "Table1"."Exponent" )

Input

Output

Table1

Base : INT

Exponent : INT

1

2

2

3

3

4

2

null

null

3

Result

Column1 : FLOAT

1.0

8.0

81.0

null

null

[2] Calculate the power using a constant value as exponent.

Query

Column1

POWER ( "Table1"."Base" , 2 )

Input

Output

Table1

Base : INT

1

2

3

Result

Column1 : FLOAT

1.0

4.0

9.0

See also: