I am trying to create a report which would show me all the Contacts where the "Household Mailing Address" is not blank. I've started by using "Contacts and Accounts" report type, but it's bringing also records where this field IS blank, so I can't quite understand why it's not filtering "Household Mailing Address" not equal to blank.
I've tried creating a custom report type which would show ONLY Contacts, but that also doesn't work.
I've tried creating a row-level formula to return to true if this field is not blank, but this field is not showing in the list of the available fields.
I just don't know why it's not filtering... amd what kind of a mysterious field it is that it's not showing in formula builder...
Please help!
Maybe try the report filter with multiple fields - each component of the address ie
Street blank AND
City blank AND
etc
Address is a composite of these. Can’t remember how this behaves in report right now.
If that doesn’t help, check this out, though I don’t believe this is your root cause
https://help.salesforce.com/s/articleView?id=000382125&language=en_US&type=1
