I am trying to get a report of X-without-Y type kind of report.

So I created a Formula field (Number,0) with value of '1' for every Object (Account, Contact, Oppty, etc )

enter image description here

I than created a Custom Report type

enter image description here

Created a report using the custom report type, and added a filter to display all Accounts where Contact is not equal to 1

enter image description here

ALAS: The report returns accounts that DO have records, even that these do NOT show on the report itself

  • In the following example: Company : no - has no shown contacts

enter image description here

  • when looking on the 'no' object - there is a contact

enter image description here

  • What an I missing?
  • This happens both with Account <> Contacts, Account <> Opportuinties

1 Answer 1


You selected Accounts WITH or WITHOUT Contacts, therefore, the report is going to ignore your filter criteria and will pull records that "apparently" don't match. You can create this type of reports using cross filters

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.