ROUNDDOWN
Description:
This function rounds up (floor) the given value.
Return type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Numeric_Expression | Numeric expression to apply the mathematical Round operation. |
Numeric_Expression | This is the value upto which decimal places, the given value needs to be round up. |
Example:
WITH MEMBER [Measures].[Result] AS ROUNDDOWN([Measures].[Sales]) SELECT [Measures].[Result] ON 0 FROM [AdventureWorksMF]