Forum Discussion
Solved
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 ...
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:
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