Count, Count Distinct, & Count Display

Understand the difference between COUNT, COUNT (Display), and COUNT (Distinct) to get the most accurate results from your reports. Each option counts differently — knowing which to use ensures you're seeing the right number for the right reason. COUNT tallies the total number of rows that meet your criteria, including duplicates. Use this when you want a raw total regardless of how many times a value appears. COUNT (Display) performs the same count but also shows the individual records behind the number — one row per ID. Use this when you need both the total and a breakdown of what was counted. COUNT (Distinct) counts each unique value only once, no matter how many rows it appears in. Use this when you want to know how many different entities exist, such as unique people, departments, or invoice numbers. If your COUNT result seems higher than expected, try COUNT (Distinct) to see if duplicates are inflating the number. If you need to audit what's being counted, COUNT (Display) gives you that visibility.