FLOOR

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

Syntax

FLOOR(value) - > number

Arguments

Arguments	Datatype	Description

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

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

Remarks

Without using FLOOR, the result would be:

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec