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 )
I than created a Custom Report type
Created a report using the custom report type, and added a filter to display all Accounts where Contact is not equal to 1
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
- when looking on the 'no' object – there is a contact
- What an I missing?
- This happens both with Account <> Contacts, Account <> Opportuinties
Best Answer
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