The FLOOR function rounds a number toward zero to the nearest specified multiple of significance. It accepts numeric values or node references as arguments and returns the rounded result based on the given multiple.
Syntax
FLOOR(value,significance)
Arguments
value: Number or node reference to round.
significance (Optional): The multiple to which the number should be rounded. If not specified, the number is rounded down to the nearest integer toward zero.
Return value
Returns the number rounded toward zero to the specified multiple.
Example
FLOOR(PlannedUnits,3)
In this example, the FLOOR function is used to create the Rounded Off Units measure, which returns the values in the Planned Units measure rounded down to the nearest multiple of 3.
