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.