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 |

## Related resources

- [Calculated fields](https://docs.cloud.google.com/data-studio/about-calculated-fields)
- [Data Studio function list](https://docs.cloud.google.com/data-studio/function-list)