Print Page - Summarize '%' issue

Title: Summarize '%' issue
Post by: MC Paris on 28 Sep 2013 03:25:32 AM

Hi everybody,

Report studio 10.2.1

I had some issue with the summarize in %.

List: country - product - sales measure - % Y vs Y-1
Filters: the user can choose the country(ies) and the product(s) via a container filter.
So the list is updating by the choice of the user.

I use "Summarize in Output" and the "sales measure" total is ok but not the "% Y vs Y-1" total, it makes the sum of "% Y vs Y-1". :'(

Thank you for you help.

Title: Re: Summarize '%' issue
Post by: JBCLARK20 on 18 Oct 2013 08:34:56 AM

HI MC Paris,

I encountered a similar issue and found the Aggregate function to be useful in calculating percentages.
In a query create a data item: aggregate ([data item1]) / aggregate ([data item2])
On the report, set the data format to percent.

Title: Re: Summarize '%' issue
Post by: MC Paris on 16 Nov 2013 03:02:26 AM

Hi JB,

thx for your trick, I will try it and tell you if it's ok.

Title: Re: Summarize '%' issue
Post by: chalapati4u on 21 Aug 2015 09:37:03 AM

Hi

I also have similar issue, Did any find the solution.
Please share me.

thanks,
chala

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: MC Paris on 28 Sep 2013 03:25:32 AM