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

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 )

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

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

Query

ROUND ( "Table1"."Column1" )

Input

Output