What are aggregate calculated items?
An aggregated calculated item is a calculated item to which a GROUP function is applied (e.g. SUM, COUNT, MAX, MIN, AVG, DETAIL). The following are examples of aggregate calculations: SUM(Sal)*12 SUM(Comm)/SUM(Sal) AVG(Monthly Sales) Aggregate calculation values depend on other items used in the Discoverer Plus worksheet. How the axis items are grouped together affects the number of rows that are aggregated. This is particularly important in the case of calculations that are ratios of two aggregates. For example, to calculate a margin, you would use the calculation SUM(Profit)/SUM(Sales) rather than Profit/Sales. Used in a query, the latter would result in SUM(Profit/Sales), which produces a different result from SUM(Profit)/SUM(Sales). The example uses the SUM aggregate, but same can be applied for any of the other aggregates (e.g. SUM, COUNT, MAX, MIN, AVG, DETAIL). Note: If you want to compute the sum of a ratio of two data points, always sum data points before computing the ratio.
