Calculation Solve Order

When calculations in the rows and columns of a report intersect, calculations are performed in the following order: addition or subtraction, multiplication or division, aggregation (rollup), and then the remaining arithmetic functions.

The remaining functions are as follows:

  • absolute, round, average, minimum, maximum, medium, count
  • percentage, % difference (growth), or % of total
  • rank, quartile, quantile, percentile

If both calculations have the same precedence, for example, if they are both business functions, then the row calculation takes precedence.

You can override the order of precedence by changing the solve order property. For more information, see Resolve Multiple Calculations for Crosstabs and Charts.