COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Cognos10x on 15 Feb 2012 11:50:55 AM

Title: Issue with Crosstab summary calculations
Post by: Cognos10x on 15 Feb 2012 11:50:55 AM
Hello Gurus, I have an issue with crosstab report. I have a percentage calculations in the report in the crosstab format. The calculation is performed correctly in the details level but when it comes to summary level calculations  Its not doing the calculations in the right way.
Title: Re: Issue with Crosstab summary calculations
Post by: blom0344 on 15 Feb 2012 02:26:41 PM
the summary expression in the query will probably be something like:

total(current measure  ............)

You need to change this to the proper aggregate , probably  :

average(current measure  ............)