troubleshooting Question

Count different string values in a group

Avatar of John-S Pretorius
John-S PretoriusFlag for United States of America asked on
Crystal Reports
4 Comments2 Solutions124 ViewsLast Modified:
I am grouping by a specific field (Transaction Number), within each group I have a specific value that should always be the same within that group. The total group count varies, I want to count how many different values of this specific string are in each group:-

11000012956  (The group count should be 1 as the value is the same within the group)
AA12BBCC
AA12BBCC
AA12BBCC
11000012957 (The group count should be 3 as the value has 3 different values in this group)
DD5612BB
DD56DD12
12DD5611
ASKER CERTIFIED SOLUTION
Ido Millet
Owner, Millet Software

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

Join our community to see this answer!
Unlock 2 Answers and 4 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 2 Answers and 4 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