Calculation Solve Order
When calculations in the rows and columns of
a report intersect, IBM® Cognos® Analysis Studio performs
the calculations in a specific order.
The order in which Analysis Studio performs calculations is as follows:
- addition or subtraction
- multiplication or division
- aggregation (rollup)
- remaining arithmetic functions: absolute, round, round down, average, minimum, maximum, medium, count
- percentage, % difference (growth) or % of total
- rank, quartile, quantile, or percentile
If both calculations have the same precedence, for example, if they are both business functions, then the row calculation takes precedence.
If you have the necessary permissions, you can open your analysis in IBM Cognos Report Studio and override the order of precedence by changing the solve order property. For more information, see the IBM Cognos Report Studio User Guide.