floor

Type

Math Function

Purpose

The floor function rounds down a numeric value to the next lowest integer.

Syntax

floor(NUMERIC VALUE)

Returns

An integer value.

Usage

The numeric value in a math function can be a constant value (as shown below), a variable, a field value or an expression.

Examples

floor(5.000)

Returns: 5

floor(5.999)

Returns:5