COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: vivek.bevan on 19 Sep 2008 10:43:21 AM

Title: How to show percentage and a number in the same cell of a crosstab
Post by: vivek.bevan on 19 Sep 2008 10:43:21 AM
Hello All,

I want to show a percentage and its numerator in the same cell of an crosstab.
could you please advice how to do this. I tried casting percentage to the string and adding
the numerator and then displaying it but somehow it does not work.

Thanks
Title: Re: How to show percentage and a number in the same cell of a crosstab
Post by: the_xxx on 21 Sep 2008 12:02:50 AM
I tried ...manulpulating the summary cells of...crosstab...but I dont think you can manulupte them. But if you are looking to show the % sign along with the summary value...change the data format of the cell....which will be avilable on the properties pane.

:)
Title: Re: How to show percentage and a number in the same cell of a crosstab
Post by: vivek.bevan on 22 Sep 2008 12:50:48 AM
Thanks for the reply.
But actually I need to show the value in a cell as "96.5% 123".
This is somewhat a different requirement but I am sure there must be a way in cognos to do this.