troubleshooting Question

Crystal Reports: Need to get percentages from Running Total distinct counts

Avatar of PresidentLincoln
PresidentLincolnFlag for United States of America asked on
Crystal Reports
5 Comments1 Solution116 ViewsLast Modified:
have a pre-existing Crystal Report that an end-user wants me to add percentages to. I'm running into an issue because the numbers they want percentages of are Running Total distinct count fields with their own formulas.

At the end of a report, I have several Running Total fields that are distinct counts for cars, one field for a count of each color car. The sum of all of these fields equals a grant total of all cars. So it looks something like this:

Black: 5 
Red: 10
Green: 5
Yellow: 20
Total: 40

Each of the car color distinct count fields has a formula behind it to give us the number, and then the "Total" field is just the distinct count of all cars - no formula.  
I need to automatically calculate and add the percentages of each of the car color rows towards the total count.  It would look like this:

Black: 5    12.5%
Red: 10    25%
Green: 5    12.5%
Yellow: 20    50%
Total: 40

So how can I get these percentages using distinct counts that themselves are already using formulas to get their numbers?  At this point I've tried using the existing formulas used to get the car color counts to next inside a new formula that would divide it by the car total, but I can't seem to get the result I want.

- This is a DB2 database (AIX)
- Using Crystal Reports
Application Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros