Rounds the input number up to the closest multiple of equal or lesser value.

Usage

Floor(number, factor)

number (required) The number or column of numbers to be rounded.

factor [optional] The multiple to which the number will be rounded. The direction of rounding is opposite that of the positive or negative sign of the factor. The factor cannot be 0. Its default value is 1.

Example

(1) Returns 3.

Floor(3.6)

(2) Returns -4.

Floor(-3.2)

(3) Returns the Floor for each row in the input column.

Floor([Cost])

Screen_Shot_2020-11-30_at_3.53.11_PM.png

(4) Returns the Floor at a factor of 0.5 for each row in the input column.

Floor([Cost], 0.5)

Screen_Shot_2020-11-30_at_3.52.53_PM.png

(5) Returns the Floor at a factor of -0.25 for each row in the input column.

Floor([Cost], -0.25)

Screen_Shot_2020-11-30_at_3.52.40_PM.png

(6) Returns the Floor at a factor of 2 for each row in the input column.

Floor([Cost], 2)

Screen_Shot_2020-11-30_at_3.52.24_PM.png

 

See Also

Ceiling - Rounds the input number up to the closest multiple of equal or greater value.

Round - Rounds the input number to the specified number of digits.

Int - Rounds the input number down to the largest integer of equal or lesser value. This function is similar to Floor, but does not support Floors optional "factor" parameter.