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:
MEMBER [Measures].[Rounded] AS ROUND([Measures].[Internet Sales Amount], 0)
SELECT {[Measures].[Squared], [Measures].[Square Root], [Measures].[Rounded], [Measures].[Absolute]}
ON COLUMNS
FROM [AdventureWorksMF_ValueBased]