Loading

Report on Accounts without Opportunities in Professional edition

Publiceringsdatum: Jun 21, 2026
Beskrivning

In Salesforce Professional Edition, Cross Object Filters are not available in reports. Therefore, it is not possible to directly create a report that displays Accounts without Opportunities using standard report filters. The recommended workaround is to create a Roll-Up Summary field on the Account object that counts the number of associated Opportunity records, then filter the report on that field.

Lösning

Create a Custom Roll-Up Summary Field on the Account Object

  • Click Setup.
    Salesforce Classic: Customize | Accounts | Fields
    Salesforce Lightning: Object Manager | Account | Fields & Relationships
  • Click New Custom Field, then set the Data Type as Roll-Up Summary.
  • For 'Field Label,' enter Opportunity Count, then click Next.
  • For 'Summarized Object,' select Opportunity.
  • For 'Roll-Up type,' select Count, then click Next.
  • Click Next, then click Save.

 

Create a Report Using the Account Object

  1. Click Reports | New Report.
  2. Select the Accounts Report type, then click Create.
  3. Select the All Accounts and Date fields per your requirements.
  4. Drag the Opportunity Count field into the filter and set the Criteria as Opportunity Count equals 0.

This report displays all Accounts without Opportunities in Salesforce Professional Edition.

Ytterligare resurser

Roll-Up Summary field

Knowledge-artikelnummer

000381953

 
Laddar
Salesforce Help | Article