FLOOR Function

Returns the largest integer that is less than or equal to the argument.

Category: Mathematical
Returned data type: Real

Syntax

FLOOR(argument)

Required Argument

argument

a real that can be specified as a numeric constant, field name, or expression

Details

This is also called rounding down.

Example

x = floor(3.5)

// outputs 3

 

x = floor(-3.5)

// outputs -4

 

x = floor(-3)

// outputs -3

 

x = floor(-3*1.5)

// outputs -5