FLOOR

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

Example formula Input Output
FLOOR(Height) 20.34 20
FLOOR(Height) -40.3 -41
FLOOR(Height) 50 50