Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

CEIL

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 Ceiling function returns the smallest integer greater than, or equal to, the specified numeric expression.

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

Syntax
CEIL ( table.column )
NULL handling

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

Example

[1] CEIL of FLOAT input with one negative value and one NULL value.

Query

Column1

CEIL ( "Table1"."Column1" )

Input

Output

Table1

Column1 : FLOAT

0.1

0.9

-1.1

0.0

null

Result

Column1 : INT

1

1

-1

0

null

See also: