ROUND
Description:
This function performs round up operation on the given value.
Syntax:
ROUND(Numeric_Expression, Numeric_Expression)
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 ROUND([Measures].[Sales]) SELECT [Measures].[Result] ON 0 FROM [AdventureWorksMF]