Skip to main content

Celonis Product Documentation

POWER
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: