Round
Syntax
Round(Numeric_Expression, [Numeric_Expression])
Input Parameters
Numeric_Expression
A valid double-precision expression to be rounded.
Numeric_Expression
A valid integer expression that specifies the fractional digits.
Optional.
Return Value
Rounds a value to the nearest integer or to the specified number of fractional digits.
note
Note: Redshift and Postgres produce results inconsistent with other dialects for Round with a second argument > 0.
Examples
Round the [Internet Sales Amount] measure to two fractional digits.
Round([Measures].[Internet Sales Amount], 2)