Skip to main content

Celonis Product Documentation

INVERSE
Description

INVERSE negates the input number.

INVERSE changes the sign of the input value, i.e. effectively multiplies with -1.

One exception is the minimum integer value, which is mapped to itself (because of Two's complement).

It can be applied to INT or FLOAT columns.

Syntax
  INVERSE ( table.column )
 
NULL handling

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

Example

[1]

Inverting integers and a NULL value.

Query

Column1

         INVERSE ( "Table1"."Column1" )
        

Input

Output

Table1

Column1 : int

2

0

-1

null

Result

Column1 : int

-2

0

1

null

[2]

Inverting the minimum value (negative) produces the minimum value (because of Two's Complement).

Query

Column1

         INVERSE ( "Table1"."Column1" )
        

Input

Output

Table1

Column1 : int

-9223372036854775808

Result

Column1 : int

-9223372036854775808