If you select a rounding option for your report, you may have to make rounding adjustments that involve setting the calculation priority and processing order. For more information about processing order, see Adjust the processing order in a report definition . For example, if calculations are performed before rounding, a 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. You can use the calculation priority setting to indicate the order in which rows and columns are calculated.

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.

Specify calculation priority

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

  2. Under Calculation priority, select one of the following options:

    • Perform column calculation first and then row– Perform the column calculations before the row calculations. This option might be necessary when a column calculation ( CALC) intersects a total ( TOT) or calculation ( CAL) row, and the row calculation should overwrite the column calculation.

    • Perform row calculation first and then column– Performs the row calculation before the column calculations. This option works best for the following situations:

      • Report with a CALCcolumn or with simple calculations

      • Row definition and column definition that use only simple mathematical operator ( +and -)

See Also