Skip to main content

Celonis Product Documentation

LOG
Description

The LOG function returns the logarithm of the specified float expression.

By default, LOG() returns the natural logarithm, but you can specify the base with an optional parameter.

It can be applied to INT or FLOAT columns.

Syntax
  LOG ( table.column [, base] )
 
NULL handling

If the input value is NULL, the result is NULL as well.

Examples

[1]

Calculate the natural logarithm of an Integer

Query

Column1

         log ( "Table1"."Column1" )
        

Input

Output

Table1

Column1 : int

4

Result

Column1 : float

1.38629436112

[2]

Calculate the logarithm of an Integer with a given base

Query

Column1

         log ( "Table1"."Column1" , 2 )
        

Input

Output

Table1

Column1 : int

4

Result

Column1 : float

2.0