> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Floor

> Use the Sigma Floor function to round the input number up to the closest multiple of equal or lesser value.

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:

<dl>
  <dt>
    number
  </dt>

  <dd>
    Required
  </dd>

  <dd>
    The number or column of numbers to apply the function.
  </dd>

  <dd>
    Note you may have unexpected results when using floating numbers, depending on the underlying database
  </dd>

  <dt>
    factor
  </dt>

  <dd>
    Optional
  </dd>

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

  <dd>
    Default is 1.
  </dd>
</dl>

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

## Example

```
Floor(3.6)
```

* Returns 3.

```
Floor(-3.2)
```

* Returns -4.

```
Floor(Cost])
```

* Returns the **Floor** for each row in the input column.

![](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/0d1f4c6877ba9a33571145fea072aa9915471157348b8be4279623eff9485d0d/assets/docs-images/d9cd47b-1.png)

```
Floor([Cost], 0.5)
```

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

![](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/9defb1b7a24a6ec064b654939b1b01f4d589d000987300137aebd501c9503deb/assets/docs-images/99f7bd8-2.png)

```
Floor([Cost], -0.25)
```

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

![](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/353803b91d39522b2326c0e48e06e8d36a26a78289b14b0d42b58c7b4eb92367/assets/docs-images/e983879-3.png)

```
Floor([Cost], 2)
```

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

![](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/f2da517696891677fabc6769e2cd9903e0cb051a782294a83702c6883b012dc6/assets/docs-images/7a7c172-4.png)

## Related resources

* [Ceiling](/docs/ceiling)
* [Round](/docs/round)
* [Int](/docs/int)