floor
Syntax Format
floor(x)
Overview
The floor function helps you to round up the indicated value type. Unlike the ceil function, floor returns the closest to the positive infinity integer value, that is not greater than the x value you indicated. The function may be useful in scripts, where the rounded values are needed rather than the decimals.
Parameters
| Parameter | Type | Purpose |
|---|---|---|
| x | series[numeric] or numeric | Input value, taken into calculation |
Returns: integer or series[integer].
Example
value1 = floor(1.6) -- equals 1
value2 = floor(6.2) -- equals 6
value3 = floor(5) -- equals 5