Round

1.3.4.4 Round

The Round processor allows you to round Number or Number Array attributes to a given number of decimal places.

Use Round where you need to transform numbers to a lower level of accuracy - for example in order to migrate numbers to a system that stores numbers differently.

The following table describes the configuration options:

Configuration	Description
Inputs	One or more Number or Number Array attributes.
Options	Specify the following options: `Decimal places`: allows decimals to be rounded to a maximum number of decimal places. Default value: `2`. `Round to nearest`: allows integers to be rounded to the nearest aggregation of a given integer, such as the nearest 10, or the nearest 100. Default value: `None`. `Round type`: drives how rounding is performed; that is, whether to round up, down or to the nearest whole value. Default value: `Nearest`.
Outputs	Describes any data attribute or flag attribute outputs.
Data Attributes	The following data attributes are output: `[Attribute Name].Rounded`: a numeric value with the result of the rounding operation.
Flags	None.

Note:

If the Round to nearest value is set, this overrides the value of the Decimal places option, and rounds values to the nearest aggregation of the given integer, such as the nearest 10 (that is, effectively sets Decimal places to 0).

The Round processor presents no summary statistics on its processing.

In the Data view, the input attribute is shown with the new rounded value to the right.

Output Filters

None.

Example

In this example, the BALANCE attribute on the Customers table is rounded to 0 decimal places:

BALANCE (asc)	BALANCE.Rounded
999999.99	1000000
74.28	74
11.6	12
0.01	0