COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: mark123 on 01 Feb 2016 03:43:01 PM

Title: Total is coming incorrect
Post by: mark123 on 01 Feb 2016 03:43:01 PM
Hi,

When i am using total in summarize options to total a column , i am not getting the total of that column.

My model is relational model.

I have attached the output screenshot.


Thanks Mark
Title: Re: Total is coming incorrect
Post by: Nagendar on 02 Feb 2016 12:00:26 AM
Quote from: mark123 on 01 Feb 2016 03:43:01 PM
Hi,

When i am using total in summarize options to total a column , i am not getting the total of that column.

My model is relational model.

I have attached the output screenshot.


Thanks Mark

try to change property for the Query: Auto Group & Summarize : Yes to No
as well as check the Aggregate Function and Rollup Aggregate Function properties of the measure.

Thanks
Nagendar
Title: Re: Total is coming incorrect
Post by: MFGF on 02 Feb 2016 03:50:19 AM
Quote from: mark123 on 01 Feb 2016 03:43:01 PM
Hi,

When i am using total in summarize options to total a column , i am not getting the total of that column.

My model is relational model.

I have attached the output screenshot.


Thanks Mark

It looks to me like you have a serious problem with your reporting package. Would you expect all the detail values to be the same? It seems very unusual that they would be. I'd be asking the person who created the package what's going on here...

MF.
Title: Re: Total is coming incorrect
Post by: bdbits on 03 Feb 2016 10:43:08 AM
It might be due to using values from two tables that do not have a relationship defined.