FLOOR
Description
Returns the largest integer number that is not greater than the provided number:
- FLOOR (5.67) = 5;
- FLOOR (-5.57) = -6
Syntax
FLOOR (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 largest integer not greater than the given number.
Example
IF FLOOR (Transaction.Amount) = 10 THEN ...