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 toX.
Examples
| Example formula | Input | Output |
|---|---|---|
FLOOR(Height) |
20.34 | 20 |
FLOOR(Height) |
-40.3 | -41 |
FLOOR(Height) |
50 | 50 |