I am trying to create a report of contacts from all my account, but I want to exclude any accounts that have open opportunities. I can't figure out how to make that work.
TIA!
Create a Custom rollup summary field on the Account object
. For 'Summarized Object,' select Opportunity
. For 'Roll-Up type,' select Count
Create a Report using the Account object
Select the Accounts Report type
Select the All Accounts and Date fields per your requirements
Drag the Opportunity Count field in the filter and add the Criteria as Opportunity Count equals to 0.
This first and second part is to select all the accounts without the opportunities now with this report created is easier to make that report a joined report and add the information of the contacts, like name, email, phone...