Skip to main content

PQL46 (PQL Function Library - CPM 4.6)

POWER

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

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 )
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