COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sravantig on 28 Feb 2012 01:29:41 PM

Title: convert turnover rate from decimal to percentage
Post by: sravantig on 28 Feb 2012 01:29:41 PM
In my combination chart
I have my measure, turnover rate in series... the turnover rate is orginally in decimals. I want to diplay it as percentage.

Please help me... i'm stuck her from days... I'm a new bie... thank you
Title: Re: convert turnover rate from decimal to percentage
Post by: blom0344 on 28 Feb 2012 02:08:21 PM
Only a pie chart will be able to give you a percentage from scratch. Otherwise you need to create a calculated item like - example :

total([measure]) / total ([measure] for report)
Title: Re: convert turnover rate from decimal to percentage
Post by: sravantig on 28 Feb 2012 08:45:05 PM
Thank you