troubleshooting Question

Percentage in crystal grouping

Avatar of robinh583
robinh583Flag for United States of America asked on
Crystal ReportsSQL
17 Comments1 Solution272 ViewsLast Modified:
I have 2 groups.
Group colors red
     Group numbers one
             x  ; 20   x : %?
             y ;  30   y: %?
             z :  20   z : %?

Group colors blue
     Group numbers two
              x  ;40
             y ;  30
             z :  20
So we have 60 x's in total. And the percentage of x's for group color red, under group number one would be (20/60* 100). How do I do this in Crystal? A running total does not have the overall x count until the end. The fact that there are 2 groups s complicating it as crystal would ordinarily let you find the % of a group total. Any ideas?

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 17 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 17 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