Ceil
ceil
rounds a decimal value to the next highest integer. For example, ceil(29.02)
returns 30
.
Syntax
Copy
ceil(decimal)
Arguments
decimal
A field that uses the decimal data type, a literal value like 17.62
, or a call to another function that outputs a decimal.
Return type
Integer
Example
The following example rounds a decimal field to the next highest integer.
Copy
ceil(salesAmount)
The following are the given field values.
Copy
20.13
892.03
57.54
For these field values, the following values are returned.
Copy
21
893
58