If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Issue with Crosstab summary calculations

Started by Cognos10x, 15 Feb 2012 11:50:55 AM

Previous topic - Next topic

Cognos10x

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.

blom0344

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  ............)