• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 48
  • Last Modified:

Count different string values in a group

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
0
John-S Pretorius
Asked:
John-S Pretorius
  • 2
2 Solutions
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Use Distinct Count.
Or, for a more robust solution (in case the string values are not sorted) ,  group at level 2 on that string value and use a Running Total (total) with evaluate for each Group Level 2.
0
 
mlmccCommented:
That sounds like the answer

If you are oing the counts on a group be sure to use the group version of the formula

DistinctCount({Field to count}, {group field})

mlmcc
0
 
John-S PretoriusTechnical Service Manager, Mid-AtlanticAuthor Commented:
Thank you both.
0
 
John-S PretoriusTechnical Service Manager, Mid-AtlanticAuthor Commented:
My apologies that works
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now