We have a custom field on the accounts page that is a drop down list of our predefined Market areas.
It is NOT a mandatory field. So there are some that are unselected, etc.
However, when i try to run a report against the accounts table, and I use criteria Market ${NOTEMPTY} to filter out unassigned ones, they show up in the report anyways.
Thoughts?