Print Page | Close Window

Percentage Values in Crosstab

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7487
Printed Date: 19 Apr 2024 at 11:46am


Topic: Percentage Values in Crosstab
Posted By: richarde
Subject: Percentage Values in Crosstab
Date 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


Replies:
Posted By: richarde
Date Posted: 25 Aug 2009 at 10:35pm

Sorry, should have stated running CR XI R2

Richard

Posted By: Crystal Method
Date 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.

Posted By: DBlank
Date 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
 
 


Print Page | Close Window