Report Design
 Crystal Reports Forum : Crystal Reports 9, X, XI, 2008, 2011 : Report Design
Message Icon Topic: Percentage Values in Crosstab Post Reply Post New Topic
Author Message
richarde
Newbie
Newbie


Joined: 25 Aug 2009
Location: New Zealand
Online Status: Offline
Posts: 2
Quote richarde Replybullet Topic: Percentage Values in Crosstab
    Posted: 25 Aug 2009 at 7:03pm
Hi,
 
I'm attempting to get a percentage value into a crosstab report - specifically I want to display the value of one running total divided by a second running total as a percentage.
 
In practical terms this means
ClosedWon/(ClosedWon + ClosedLost)
 
I can get the 2 values into the crosstab easily enough, but am struggling with the percentage format.
 
Any suggestions greatly appreciated.
 
Richard
IP IP Logged
richarde
Newbie
Newbie


Joined: 25 Aug 2009
Location: New Zealand
Online Status: Offline
Posts: 2
Quote richarde Replybullet Posted: 25 Aug 2009 at 10:35pm

Sorry, should have stated running CR XI R2

Richard

IP IP Logged
Crystal Method
Newbie
Newbie
Avatar

Joined: 06 Oct 2008
Location: United Kingdom
Online Status: Offline
Posts: 15
Quote Crystal Method Replybullet Posted: 26 Aug 2009 at 8:49am

Hi,

I would suggest simply multiplying your existing calculation by 100 and then concatenating it with the "%" symbol.

e.g.  x/(x + y) * 100&"%"

where x/(x+y) is your existing calculation.
 
Put it all in a @ formula.
Seagate Crystal Reports 8.5.0.389 in the guise of INFOR:Reports as part of Infor:COM ERP software.
IP IP Logged
DBlank
Senior Member
Senior Member


Joined: 19 Dec 2008
Online Status: Offline
Posts: 7725
Quote DBlank Replybullet Posted: 26 Aug 2009 at 9:04am
If you are just trying to format the field from "12" to "12%" then right clcik on the cell and select format field.
You can format it like any other field from here.
Use the number tab (assuming this is a number type field)
Click on Customize
click on the currency symbol tab
Enable
Change position from $-123 to -123$
Change symbol from $ to %
Hit OK and OK again
 
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.

FREE ADVANCED
Crystal Reports Training!

Plus, free bonus PDF cheat sheet! Advanced Crystal Reports Training Give Me Advanced Training!