Report on Percentage of Records a Field is Populated
Summary
This explains how to create a Salesforce report that shows what percentage of records have a specific field populated without custom fields. It solves the common problem of measuring data completeness to improve data quality and user adoption. By using a row-level formula to mark populated fields and a custom summary formula to calculate the percentage, admins can track key fields directly in reports. This approach is efficient and native, suitable for ad-hoc needs without third-party tools.
Takeaways
- Create a row-level formula returning 1 if field is populated, otherwise 0.
- Group the report by the row-level formula to segment data completeness.
- Use a custom summary formula to calculate percentage populated as SUM/RowCount.
- Display custom summary only at the Grand Total level for clarity.
- This method avoids creating additional fields and uses native reporting features.
Why This Matters Understanding how consistently users populate key fields is one of the best indicators of data quality and adoption. Incomplete data can cripple dashboards, forecasts, and automation. Measuring the percentage of records with a value in a specific field gives admins and business leaders an actionable metrics. The Goal You want a Salesforce report that answers this simple question: 16What percentage of my reocrds have this Field populated?20 For example: 85% of Opportunities have Primary Contact filled in 72% of Accounts have Industry selected 95% of Cases have Priority set For our exmaple we are going to try to determine what pecentage of Accounts have the SLA Expiration Date populated. We will accomplish this all in a Report without having to create new Fields. Step 1: Create a Row-Level Formula We will create a row-level formula with the return type of number and no decimals. Our formula is below. It returns a 0 if the Filed is not populated and a 1 if it is.