Default Evaluation Order

The default order of calculation is as follows:

1. Compound smart metrics
2. Consolidations, which are evaluated by their relative position on the report template:
• Rows, from left to right
• Columns, from top to bottom

  For examples of how evaluation order affects consolidations, see the following:

  • Evaluation Order, discusses multiple consolidations on a single report.
  • Evaluation Order in Data Definition and View Definition, demonstrates the interaction of a consolidation, subtotals, and the view definition with the evaluation order.
3. Report limits
4. Subtotals

Compound metrics that are not the direct aggregations of other metrics can be used in the evaluation order by setting the Allow Smart Metrics option of the Metric Editor to Yes.

Page-by and sorting are determined last, to arrange the positions of the calculation results. Their evaluation order cannot be changed.