Print Page - how to show correct total for percentage column in list report

Title: how to show correct total for percentage column in list report
Post by: nsaxena on 06 Aug 2015 05:04:01 AM

Hi All ,

I have a list report in which column are like this

city country fact1 fact2
delhi india 10 10%
paris france 20 15%

fact one is numeric(numbers) and fact2 is showing a percentage value...

Now i want to show total of all the fact columns...when i am doing by selecting total i am getting fact2(percentage column as sum up too)
city country fact1 fact2(percentage)
delhi india 10 10%
paris france 20 15%
Total 30 25%

Please suggest a way to avoid this so that it will show real total percentage instead if sum

Title: Re: how to show correct total for percentage column in list report
Post by: krishdw85 on 06 Aug 2015 05:51:01 AM

percentages do average

Title: Re: how to show correct total for percentage column in list report
Post by: nsaxena on 06 Aug 2015 06:03:56 AM

hi..i do not need average...

my calculation for fact(percentage field is ) : data item 1/total

Title: Re: how to show correct total for percentage column in list report
Post by: Nagendar on 06 Aug 2015 06:40:28 AM

Hi Nsaxena,

Try to use "Rollup Aggregate Function" (ex: Calculated) Property and "Data Format" (ex: Percent).

Thanks
Nagendar

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: nsaxena on 06 Aug 2015 05:04:01 AM