We are trying to pull a list of individuals not part of a household for some database clean-up, and even with the criteria Constituent Type-In-Individual and Constituent Type-Not In-Household we are still getting constituent results that are a part of a household.
Has anyone else encountered something like this before? Do we need to go into Manuel Entry and edit it there?
Any insight is appreciated!
Probably easiest manually, but you could also find household, replace household with affiliates, and then use that list as an exclusion list for a list of individuals.