Skip to main content

PQL46 (PQL Function Library - CPM 4.6)

FLOOR

Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6

Description

The FLOOR function returns the greatest integer smaller than, or equal to, the specified numeric expression.

It can be applied to FLOAT columns. The result is a column of type INT .

Syntax
FLOOR ( table.column )
Example

[1] FLOOR of FLOAT column with one negative value and one null value.

Query

Column1

FLOOR ( "Table1"."Column1" )

Input

Output

Table1

Column1 : FLOAT

0.1

0.9

-1.1

0.0

null

Result

Column1 : INT

0

0

-2

0

null