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