Skip to main content

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! 

 

Contact Report where the Account has no Active Opps

 

#Reports & Dashboards

2 个回答
  1. 2024年3月15日 14:18

    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...

     

    Create a Custom rollup summary field on the Account object. For 'Summarized Object,' select Opportunity.