Skip to main content

Celonis Product Documentation

FLOAT

Description

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

Floating point constants are defined in US style with a dot as 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: