COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Chamopak on 18 Jul 2019 12:58:10 PM

Title: Wrong total in Calculation List report
Post by: Chamopak on 18 Jul 2019 12:58:10 PM
Hi,

I created a list report that with a filter that only takes a portion of the data.
But when I add the total report, it will not add the correct total. The numbers are much higher that its suppose to
See attachment.


Yellow is what it is suppose to be (total) and blue is what its calculating (WAY OFF).

Thank you in advance for your help.
Title: Re: Wrong total in Calculation List report
Post by: MFGF on 18 Jul 2019 01:11:20 PM
Quote from: Chamopak on 18 Jul 2019 12:58:10 PM
Hi,

I created a list report that with a filter that only takes a portion of the data.
But when I add the total report, it will not add the correct total. The numbers are much higher that its suppose to
See attachment.


Yellow is what it is suppose to be (total) and blue is what its calculating (WAY OFF).

Thank you in advance for your help.

Hi,

Are you using a relational package or a dimensional package?
How is the total defined at the moment? Is it an automatic summary or is it a calculated value in the report (and if so, how is it being calculated)?
How is the filter defined?

Cheers!

MF.