# Floor

The **Floor** function rounds the input number up to the closest multiple of equal or lesser value.

Note that you may have unexpected rounding results when applying **Floor** to float data types; this behavior depends on how the underlying data warehouse calculates the function.

## Syntax

Floor(number, factor)

The function has these arguments:

- number
- Required
- The number or column of numbers to apply the function.
- Note you may have unexpected results when using floating numbers, depending on the underlying database
- factor
- Optional
- The multiple to apply to the Floor function. The direction of rounding is opposite that of the positive or negative sign of the factor. The factor cannot be 0.
- Default is 1.

The Floor function may return unexpected results if the input column is coming from float data type.

## Example

- Returns 3.

Floor(3.6)

- Returns -4.

Floor(-3.2)

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

Floor([Cost])

- Returns the
**Floor**at a factor of 0.5 for each row in the input column.

Floor([Cost], 0.5)

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

Floor([Cost], -0.25)

- Returns the
**Floor**at a factor of 2 for each row in the input column.

Floor([Cost], 2)

## Related functions

- 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.