> 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://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/0d1f4c6877ba9a33571145fea072aa9915471157348b8be4279623eff9485d0d/assets/docs-images/d9cd47b-1.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20260817%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20260817T042857Z&X-Amz-Expires=604800&X-Amz-Signature=6288dea855823e18453ec701a853fa420fb772be140554bd63a5ded4e861f49e&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)

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

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

![](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/9defb1b7a24a6ec064b654939b1b01f4d589d000987300137aebd501c9503deb/assets/docs-images/99f7bd8-2.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20260817%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20260817T042857Z&X-Amz-Expires=604800&X-Amz-Signature=92891adf9f7d7c61e66cb9270c69912258a348cf75d3681125b34d39a66c0345&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)

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

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

![](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/353803b91d39522b2326c0e48e06e8d36a26a78289b14b0d42b58c7b4eb92367/assets/docs-images/e983879-3.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20260817%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20260817T042857Z&X-Amz-Expires=604800&X-Amz-Signature=1aea5b5712c13e9da3517226690df8558a69715acb796f8690dfaa44e0f399f2&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)

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

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

![](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/f2da517696891677fabc6769e2cd9903e0cb051a782294a83702c6883b012dc6/assets/docs-images/7a7c172-4.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20260817%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20260817T042857Z&X-Amz-Expires=604800&X-Amz-Signature=ec54611c3b03f03163ccb1f83abf02a07a311b3a92774c3747a6af2be1ef8bb8&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)

## Related resources

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