Print Page | Close Window

Percent symbol not showing up in charts

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4830
Printed Date: 03 May 2025 at 4:21am


Topic: Percent symbol not showing up in charts
Posted By: judylynn
Subject: Percent symbol not showing up in charts
Date Posted: 18 Nov 2008 at 8:16am
I have a problem with getting the "%" symbol to show up on the value in charts. I know about the format options on the "Options" tab of the Chart Expert, as well as the "Set Summary Operation" on the Data tab of the Chart Expert. When I use these, I get the symbol but the decimal places are all wrong. For example "12.0%" shows up as "1200.0%". The only other alternative is to show 12.0 with no % sign, which makes it look like it's a number and not a percent.
Can anyone help with this problem?


Replies:
Posted By: rahulwalawalkar
Date Posted: 19 Nov 2008 at 1:31am
Hi
 
What Chart Type are you using......
 
Cheers
Rahul

Posted By: judylynn
Date Posted: 19 Nov 2008 at 5:41am
It is a vertical side by side bar chart.

Posted By: rahulwalawalkar
Date Posted: 19 Nov 2008 at 8:07am
Hi
 
Do this here is the trick
 
I have created a formula to calculate % and divided by 100
 
{Financials.Net Sales} % {Financials.Cash}/100
 
then simply create your chart display data label values in bar
 
then format data lablel select percent and 2 decimal places 
 
 you have the correct figure with % symbol.
 
you have to divide the original value with 100 as the percent option in format datalabel is dividing the datavalues by 100 do wrong results so basically you are dividing the original values by 100 to get 0.12
 
and then in chart labels you are showing them as % with 2 decimal places converting to 12%
 
 
 
Cheers
Rahul
 
 

Posted By: judylynn
Date Posted: 24 Nov 2008 at 7:20am

This works great- thanks!


Posted By: jlb1
Date Posted: 10 Dec 2008 at 2:51pm
hi judy try the following:
{number 1}/{number 2}*100&"%"
This should add the % sign to the result ie 12%.
Take care,


-------------
take care


Print Page | Close Window