In cognos report studio, we can specify aggregation type such as Total, Minimum, etc. for query items in a query subject
What is the purpose of "calculation" aggregation type ? Under which scenario will we use it practically? Request to explain with example.
Quote from: shadowhunter on 24 Nov 2014 12:32:20 PM
In cognos report studio, we can specify aggregation type such as Total, Minimum, etc. for query items in a query subject
What is the purpose of "calculation" aggregation type ? Under which scenario will we use it practically? Request to explain with example.
It's typically used where you want to perform an aggregation than is calculated from other aggregations.
Consider a list with three columns from your package - Product, Revenue and Target. You then add a fourth calculated column to your list - % Of Target, which divides Target by Revenue (and formats as %). Now you want aggregates at the end of your list. Assuming both Revenue and Target are set to Sum, you have two options for the calculated column:
1. Set it to Sum also. This will add up all the percentages in the column and provide a rather ridiculous value in your footer.
2. Set it to Calculated. This will take the Revenue and Target aggregated values from the footer and use them to calculate the overall % Of Target.
MF.