Skip to main content

PQL46 (PQL Function Library - CPM 4.6)

ROUND

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

Description

The ROUND function rounds a numeric value to the closest whole number.

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

Syntax
ROUND ( table.column )
Example

[1] ROUND of positive FLOATs, negative FLOAT and a NULL value.

Query

Column1

ROUND ( "Table1"."Column1" )

Input

Output

Table1

Column1 : FLOAT

1.1

1.4

1.6

-1.1

null

Result

Column1 : INT

1

1

2

-1

null