CEIL
The following section describes the syntax and usage of the CEIL function in ActivityInfo.
Description
The CEIL function is used to round a value upwards to the nearest whole number.
Syntax
CEIL(value)
| Argument | Required | Description |
|---|---|---|
| value | Yes | The value you wish to round upwards. The value must be numeric. |
Result
The nearest whole number when rounding up from the given value.
Example
We will be using the CEIL function to calculate a rounded value from an argument.
Arguments
We will be using the Quantity Field "Value" with Field Code "VAL".
Formula
CEIL(VAL)
Results
