Rounding adjustments may be necessary if a report is generated in whole pounds or one of the other rounding options available in the report settings. How a report is displayed is also affected by the processing order of calculations in relation to rounding.

You can specify a level of rounding for the numerical values in a report on the Settingstab of the report definition.

If you select a rounding option for a report, you may have to make rounding adjustments, which involves setting the calculation priority and processing order.

For example, if calculations are performed before rounding, the balance sheet may balance, but not foot. If rounding is performed before calculations, the balance sheet will foot. However, the two sections (assets compared to liabilities and equity) may not balance. For more information about rounding adjustments, see Adjust rounding in a row definition .

Note Note

The term footmeans to total down to the row calculation. The term cross-footmeans to total across, rolling up the child units to the parent unit.

Change the level of rounding used in your report

  1. In Report Designer, open the report definition to modify. Click the Settingstab.

  2. In the Rounding precisionfield, select a rounding option for the report. For a description of rounding options and examples, see the rounding options and the example later in this topic.

Rounding options

The following table describes the rounding options.

Rounding Option

Rounding Example

No Rounding

$1,117,691,601.48

Whole Pounds

$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

Examples

When you round a report, you can select to round the report values before or after totalling, and you can select 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.

Rounding Selections

Foot?

Cross-foot?

Roll up Rounded Values in the Tree

No

Yes

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

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

Accounts

U.S.

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 notuse rounded values in calculations and totals.

Example 1

Example 2

Roll up Rounded Values in the Tree

 

U.S.

Canada

Combined

U.S.

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

See Also