Amazon QuickSight
User Guide

The AWS Documentation website is getting a new look!
Try it now and let us know what you think. Switch to the new look >>

You can return to the original look by selecting English in the language selector above.

round

round rounds a decimal value to the closest integer if no scale is specified, or to the closest decimal place if scale is specified.

round is supported for use with analyses based on SPICE data sets.

Syntax

round(decimal, scale)

Arguments

decimal

A field that uses the decimal data type, a literal value like 17.62, or a call to another function that outputs a decimal.

scale

The number of decimal places to use for the return values.

Return Type

Decimal

Example

The following example rounds a decimal field to the closest second decimal place.

round(salesAmount, 2)

The following are the given field values.

20.1307 892.0388 57.5447

For these field values, the following values are returned.

20.13 892.04 58.54