This function returns the ceiling value. i.e. the smallest mathematical integer that is greater than or equal to the given number.

Syntax
ceil(number) #Output: Number
Examples
Parser expressionDescription
%{ceil(-1.3)}

This example returns:

-1

%{ceil(0)}

This example returns:

0

%{ceil(2.3)}

This example returns:

3

Additional information

Parameters used in this function

ParameterInput (data type)Description
number

NUMBER

Any given number or numeric field code.
Output

This function returns a NUMBER


Use cases and examples