Skip to main content

Celonis Product Documentation

FLOAT

Description

The Celonis implementation of floating point numbers follows the IEEE Standard for Floating-Point Arithmetic (IEEE 754) with 64-bit precision. Floating point numbers that hold not-a-number (NaN) values are mapped to NULL.

Floating point constants use a period as the decimal separator.

Example

[1]

Create three float values:

Query

Column1

         - 0.5
        

Column2

         0.0
        

Column3

         0.5
        

Input

Output

Result

Column1 : float

Column2 : float

Column3 : float

-0.5

0.0

0.5

See also: