Returns the nearest integer less than or equal to the specified value.
Sample usage
FLOOR(Height)
Syntax
FLOOR(X)
Parameters
X
- a field or expression containing at least one field.
Note
FLOOR(X)
is always less than or equal to X.
Examples
Formula | Input | Output |
FLOOR(Height) |
20.34 | 20 |
FLOOR(Height) |
-40.3 | -41 |
FLOOR(Height) |
50 | 50 |