Print Page - [SOLVED] Display % in total row

Title: [SOLVED] Display % in total row - list report.
Post by: ipmurali on 27 Sep 2011 11:38:58 AM

Hi all,

I am using COGNOS 8.3
I need to display the % in different columns as explained in the attached screen shot.

Appreciate your help.

Thanks in advance.

(https://lh5.googleusercontent.com/-18Z5ziqZbqI/ToH6VgaxJOI/AAAAAAAAEjs/LFze1N__gOw/s800/persistancy_scr.PNG)

Title: Re: Display % in total row - list report.
Post by: MFGF on 27 Sep 2011 12:44:49 PM

Which part are you struggling with? I guess a simple list should suffice, with calculations to divide each month by the converted value, then formatted as percent.

Regards,

MF.

Title: Re: Display % in total row - list report.
Post by: ipmurali on 27 Sep 2011 01:39:05 PM

Thanks MF for your quick response

In the total row 1%,2%,3% ... values not coming as i expected.
I created a simple list report only.
1% is calculated as [MONTH1]/[CONVERTED] and put % format the values are coming correctly for the detail rows.
but when it comes to last row (Total)

it is calculating as 237/238 = 99.58%
but what i need here as 237/237 = 100.00%

similarly 2% is calculating as 199/238=83.61
i need as 199/200=99.50%

(in the report what i designed always calculating % to the total converted 238, what i am looking it should vary month to month)

hope this explained well what i am looking for..

thanks

Title: Re: Display % in total row - list report.
Post by: MFGF on 27 Sep 2011 02:23:32 PM

Hi,

I'm not clear where your denominator values are coming from? For example, in the 1% column, where does the 237 denominator come from? In the 2% column, where does the 200 denominator come from? I don't see these anywhere in the data.

Sorry if I'm missing something obvious, but I can't see where these numbers are derived.

Thanks,

MF.

Title: Re: Display % in total row - list report.
Post by: ipmurali on 27 Sep 2011 11:30:40 PM

Hi MF,

Denominator values are the sum(converted) of those having MonthN values.
ie
Denominator for Month1 it would be
237 = 60+20+35+56+11+18+37

Denominator for Month2 it would be
200=60+20+35+56+11+18

Denominator for Month2 it would be
182=60+20+35+56+11

and so on ...

hope it is clear to you now ...

Thanks,

Title: Re: [SOLVED] Display % in total row - list report.
Post by: ipmurali on 29 Sep 2011 09:00:02 AM

Guys,

Solved by creating individual CONVERTED columns for 12 months. ;)
Could not find any other solution for it.

Thanks.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ipmurali on 27 Sep 2011 11:38:58 AM