Skip to main content

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])