Floor

Syntax

FLOOR(Numeric_Expression)

Input Parameters

Numeric_Expression
A valid numeric expression, such as a numeric Measure reference or a numeric literal.

Return Value

Returns the largest integer less than or equal to the decimal value argument.

Examples

Return the Sales Amount rounded down to the nearest dollar.

FLOOR([Measures].[Internet Sales Amount Local])