---
schema_version: "1"
id: 25f3bf7653fd5e40ea868070a0ed35fff190ae8a7ef7c4c58c544df64fec5f69
title: floor(n)
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_saql/guides/reference/bi-saql-functions-math-floor.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-math-floor.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 21ed4b82a9ed0a26b634302b03d514a690326f82c89afd3c6c4c1bb1e7e9f4a0
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# floor(n)

Returns the nearest integer of equal or lesser value to _n_. _n_ can be any real numeric value in the range of -1e308 \<= n \<= 1e308. This function can only be used in a `foreach` statement.

## Example

```nolang
q = foreach q generate floor(miles) as distance;
```