Classifying a group and then count based on the classification
Posted on 2012-03-23
I have a report in which I used the details section to classify my group. I classified the group based on some selection and sorting formulas. I now want to know how many of each type of group that I have based on the classification that I determined. I tried using three running formulas that evaluated only a certain value, but the running total counts the information in the details section so I end up with inflated numbers.
My data is set up like so:
Group Name Group Classification based on detail
So it looks like this with data
case_ID Type A
Case_ID 2 Type B
Case_ID3 Type C
So my goal would be to have a total that tells me that I have one of each type of group. My running totals though are giving me a total of 1 for group A, 1 for group C, but 3 for group B.
Can I do what I want to do here? This has plagued me for sometime and I am at a complete mental block so I am open to any suggestions. I just need to get rid of my inflated numbers and make sure that each case_id (i.e. each group) is only counted once. The difference is about 200 records and it is really messing up my statistics.
Also I have an intermediate level of crystal experience so very explicit instructions in any suggestions would be most appreciated.