Wrong totals in Report

[ghostraider]

Hi All,

I have a couple of Cognos reports where i have my query giving me the right data but the totals are way off. I have run the same query using Toad and using a subquery i counted the totals for the required column and they look perfectly ok. Could you guys let me know the most common reasons for why totals would be wrong?

Thanks for your time.

[blom0344]

You'll notice that if you check the generated SQL in the report that adding a total to a column does not change the SQL. So, the Cognos server itself is reponsible for calculating the resulting total.
There is no direct dependancy on the individual values and the total that is presented in the report.

The first thing to do is check the aggregate types. Are the totals too low or (much) to high?