# FLOOR

The FLOOR function returns the rounded down value of the specified number or node.

### Syntax

FLOOR(value) - > number

### Arguments

<table><thead><tr><th width="159">Arguments</th><th width="148">Datatype</th><th>Description</th></tr></thead><tbody><tr><td>value</td><td>Number/Node reference</td><td>The value or the node name that has the values to be rounded down.</td></tr></tbody></table>

### Example

In the below example Sales target to achieve is 2200 and employee sales are given. Employees will receive 2% incentive of sale price for sales made more than the target. The sales price of a product is 1254. We need to calculate the incentive received by employee.

<table><thead><tr><th width="159"></th><th width="144">Jan</th><th width="64">Feb</th><th width="64">Mar</th><th width="64">Apr</th><th width="64">May</th><th width="64">Jun</th><th width="64">Jul</th><th width="64">Aug</th><th width="64">Sep</th><th width="64">Oct</th><th width="64">Nov</th><th width="64">Dec</th></tr></thead><tbody><tr><td><mark style="color:purple;">Sales Target</mark></td><td>2200</td><td>2200</td><td>2200</td><td>2200</td><td>2200</td><td>2200</td><td>2200</td><td>2200</td><td>2200</td><td>2200</td><td>2200</td><td>2200</td></tr><tr><td><mark style="color:orange;">Employee Sales</mark></td><td>1850</td><td>2134</td><td>2489</td><td>1783</td><td>1965</td><td>2498</td><td>1934</td><td>2356</td><td>2793</td><td>3120</td><td>1897</td><td>2185</td></tr></tbody></table>

To achieve this, the following formula should be written in the \[Incentive] node

<mark style="color:blue;">**`FLOOR`**</mark>**`(`**<mark style="color:blue;">**`IF`**</mark>**`((`**<mark style="color:orange;">**`[Employee Sales]`**</mark>**`>`**<mark style="color:purple;">**`[Sales Target]`**</mark>**`),(`**<mark style="color:orange;">**`[Employee Sales]`**</mark>**`-`**<mark style="color:purple;">**`[Sales Target]`**</mark>**`),0) * 1254 * 0.02)`**

### **Result**

<table><thead><tr><th width="159"></th><th width="144">Jan</th><th width="64">Feb</th><th width="64">Mar</th><th width="64">Apr</th><th width="64">May</th><th width="64">Jun</th><th width="64">Jul</th><th width="64">Aug</th><th width="64">Sep</th><th width="64">Oct</th><th width="64">Nov</th><th width="64">Dec</th></tr></thead><tbody><tr><td>Incentive</td><td>0</td><td>0</td><td>7248</td><td>0</td><td>0</td><td>7473</td><td>0</td><td>3912</td><td>14872</td><td>23073</td><td>0</td><td>0</td></tr></tbody></table>

### Remarks

Without using FLOOR, the result would be:

<table><thead><tr><th width="159"></th><th width="144">Jan</th><th width="64">Feb</th><th width="64">Mar</th><th width="64">Apr</th><th width="64">May</th><th width="64">Jun</th><th width="64">Jul</th><th width="64">Aug</th><th width="64">Sep</th><th width="64">Oct</th><th width="64">Nov</th><th width="64">Dec</th></tr></thead><tbody><tr><td>Incentive</td><td>0</td><td>0</td><td>7248.12</td><td>0</td><td>0</td><td>7473.84</td><td>0</td><td>3912.48</td><td>14872.44</td><td>23073.6</td><td>0</td><td>0</td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.valq.com/model/formula-functions/math-functions/floor.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.