I am trying to create a report that shows ONLY the customers who have specific fields that are empty (address, phone number, etc). How do I set up this filter?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I know I need to select the field, but then I don't know what to use next (contains, does not contain, etc) so that I am only reporting fields that are empty (or blank).

Thank you.


Photo of benecia1111


  • 80 Points 75 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,264 Points 20k badge 2x thumb
I do precisely this when manually cleaning up a database looking for missing phone, emails etc

[Email] "is equal to" "the value" <empty>

By <empty> I mean just leave the last text field blank - with nothing entered.