# 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>