CEILING
Description
Returns the smallest integer number that is not less than the provided number:
- CEILING (5.67) = 6;
- CEILING (-5.57) = -5
Syntax
CEILING (number)
Can be used in the condition of a FIND action.
Parameters
Attribute of the Number type or number constant or calculation producing number
Returns
Number: the smallest integer not less than the given number
Example
IF CEILING (Transaction.Amount)=10 THEN ...