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)