> For the complete documentation index, see [llms.txt](https://concentra-analytics.gitbook.io/working-with-data/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://concentra-analytics.gitbook.io/working-with-data/numbers/floor.md).

# Floor

This can be useful in certain mathematical scenarios e.g. when calculating age (where you don't want to round up the number of years).

NB. For most tools, FLOOR rounds the number down to the nearest integer. In Excel, it rounds the number down to the specified degree of significance.

## Excel

\=\~FLOOR!\~(‹number›, ‹significance›)

```
=FLOOR(1.58,0.1)
//Returns 1.5, ie rounding 1.58 towards zero to the nearest multiple of 0.1
```

NB. Inputs need to have the same sign.

## Tableau

\~FLOOR!\~(‹measure›)

```
FLOOR(1.58) // Returns 1
```

## Alteryx

\~FLOOR!\~(‹measure›)

```
FLOOR(1.58) // Returns 1
```

## OrgVue

\~Math.floor!\~(‹measure›)

```
Math.floor(1.58) // Returns 1
```

NB. Make sure to use `Math` and not `math`. "Math" is a library of functions which contains `floor`; "math" is a function itself.

## tSQL

\~FLOOR!\~(‹measure›)

```
SELECT FLOOR(1.58) 
FROM Table
-- Returns 1
```

## Python

\~math.floor!\~(‹measure›)

```
import math

math.floor(1.58) # Returns 1
```

NB. This requires the `math` library to be imported.