Determining evaluation order of calculations

You can change the evaluation order of various objects on a report to affect how data is calculated for a given report. You can change the evaluation order of consolidations, compound smart metrics (which are compound metrics with smart totals enabled), report limits, and subtotals.

The default evaluation order on a report is:

1. Compound smart metrics

2. Consolidations, which are evaluated by their relative position on the report grid:

   • First, rows from left to right
   • Then, columns from top to bottom
3. Report limits
4. Subtotals

Notice that the metrics that are included in the evaluation order are compound smart metrics. A metric must have smart totals enabled for the evaluation order to affect it, otherwise the metric is always calculated first. Only compound metrics can have smart totals enabled.

For steps to change the evaluation order of these objects on a report, see Evaluation order of calculations in Analyzing Data.

For additional information on changing the evaluation order of objects on a report, see the following chapters of the Advanced Reporting Help:

• For the evaluation order of multiple consolidations, see the Custom Groups and Consolidations chapter.
• For the evaluation order of all other report objects, see the Reports chapter.

For more information on compound metrics and smart totals, see Metrics made up of metrics: Compound metrics and Totals and subtotals.