How do I filter a Salesforce report for not equal to blank?

Add a filter on the field, set the operator to not equal to and leave the value box empty. The report keeps only records where the field has a value. Use equals with an empty value to show only the blank records.

How do I handle null values or n/a values in a Salesforce report filter?

A truly empty field is handled by leaving the value box empty. Text such as N/A or None is a real value, so add a second filter, for example Field not equal to N/A , and join the filters with AND. An empty picklist shows as --None-- or a dash, but you cannot type that into the filter.

Can I filter by multiple values in a Salesforce report?

Yes. Enter the values separated by commas in one filter value box, or add separate filters and combine them with filter logic such as 1 AND (2 OR 3). See how to filter multiple values in a Salesforce report .

How do I find records that have no related records?

Use a cross filter with the Without option, for example Accounts without Contacts. A normal field filter cannot check for missing child records.

Why does the blank filter not work on my date field?

Equals and not equal to comparisons on date fields can give unexpected results. Create a row-level formula with ISBLANK and filter on its result, then check the count against a record you know is blank.

How to Filter Out Null Values in Salesforce Report

To filter out null values in a Salesforce report, add a filter on the field, set the operator to not equal to, and leave the value box completely empty. The report then keeps only records where that field has a value, and every blank (null) row disappears. This is the answer to the common search “salesforce report filter not equal to blank”, and it works the same way for text, number, picklist and lookup fields.

I ran into this when a sales manager asked me for an annual revenue report on accounts. Many account records had nothing in the Annual Revenue field, so the totals and averages were misleading. In this tutorial I will show the exact steps, how the same trick behaves on different field types, how to combine it with filter logic, and what to do when the plain filter is not enough.

This Tutorial Covers: