Filtering in the report on a particular column containing empty values will not provide expected results without using "IS NOT EMPTY" or "IS EMPTY" condition.


For Example:

Because here filter will Apply on the non-empty values for matching condition but not on the Empty values.So to avoid this, Please use another filter along with that as below.

You can try using different ways to match your requirement.But "IS EMPTY" or "IS NOT EMPTY" is required to use if there are any empty values on the filtering column.

Additional Information

For more information,Please check the related case #CS4688109 which contain detailed information.