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.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×