# Specifying Rounding in Management Reporter

The Rounding area displays the type of rounding used in the report.

## Rounding options

The following table describes the rounding options.

 Rounding Option Rounding Example No Rounding \$1,117,691,601.48 Whole Dollars \$1,117,691,601 Nearest Hundred \$1,117,691,600 Thousands (000.0) \$1,117,691.6 Whole Thousands (000) \$1,117,692 Millions \$1,117.7 Whole Millions \$1,118 Billions \$1.1 Whole Billions \$1

Although rounding produces rounding differences, or rounding errors, you can alter how and when rounding is performed to balance your need for precision and internal integrity of reports. The following two rounding options change the totals and summary reports.

## Show me an example

When you round a report, you can choose to round the report values before or after totaling and you can choose to round the reporting units before or after rolling up to the parent unit. The following table identifies the different rounding option combinations and the effect on rounding differences.

Note:  The term foot means to total down to the row calculation. The term cross-foot means to total across, rolling up the child units to the parent unit.

 Rounding Selections Foot? Cross-foot? Roll up Rounded Values in the Tree No Yes

This section shows several examples of how totals and roll ups perform using the different rounding option combinations. In all cases, Microsoft Office PerformancePoint 2007 Management Reporter consistently totals the parent unit rows after rolling up the child units.

The following table displays report values that are not rounded. All reports foot and cross-foot to the Combined report.

 Accounts USA Canada Combined Cash 1413.48 1201.20 2614.68 Accounts Receivable 287.37 100.40 387.77 Prepaid Expenses 112.47 200.05 312.52 Total Current Assets 1813.32 1501.65 3314.97

The following table contains two examples that do not use rounded values in calculations and totals.

 Example 1 Example 2 Roll up Rounded Values in the Tree USA Canada Combined USA Canada Combined Cash 1413 1201 2614 1413 1201 2615 Accounts Receivable 287 100 387 287 100 388 Prepaid Expenses 112 200 312 112 200 313 Total Current Assets 1813 1502 3313 1813 1502 3315

## Change the level of rounding used in your report

1. In an open report definition, click the Settings tab.

2. In the Rounding precision list, click a rounding option for the report.

Share