Forum Discussion
Count(Distinct) Total does not match the detail
I have a report that does a Count(Distinct) on a column that contains an ID. The lowest level detail for this column is correct. The total and any other summary totals are not correct. It is less than the actual value. The total of the details is 443and not the total shown of 439. How do I get the total and summary totals to sum to the detail?
You may have repeating/same LeadIDs in different DistrictIDs
LeadID X counts once overall BUT it will count once within each DistrictID also
so you may have this same LeadID X in District 1 and District 2 and District 3
so it will count once each time on the district level and then again only once overall
Hope this makes sense! :smileyhappy:
2 Replies
SeanCommunity Champion
You may have repeating/same LeadIDs in different DistrictIDs
LeadID X counts once overall BUT it will count once within each DistrictID also
so you may have this same LeadID X in District 1 and District 2 and District 3
so it will count once each time on the district level and then again only once overall
Hope this makes sense! :smileyhappy:
Thank you
