FLOOR

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

Syntax

FLOOR(value) - > number

Arguments

Arguments	Datatype	Description
value	Number/Node reference	The value or the node name that has the values to be rounded down.

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.

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Sales Target	2200	2200	2200	2200	2200	2200	2200	2200	2200	2200	2200	2200
Employee Sales	1850	2134	2489	1783	1965	2498	1934	2356	2793	3120	1897	2185

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

FLOOR(IF(([Employee Sales]>[Sales Target]),([Employee Sales]-[Sales Target]),0) * 1254 * 0.02)

Result

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Incentive	0	0	7248	0	0	7473	0	3912	14872	23073	0	0

Remarks

Without using FLOOR, the result would be:

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Incentive	0	0	7248.12	0	0	7473.84	0	3912.48	14872.44	23073.6	0	0