Create a Search of Customers that will Display the Projected Total of the First Opportunity

To create the search, perform the following steps:

1. Navigate to List > Search > Saved Searches > New.

2. Select Customer.

3. Provide a Search Title.

4. In the Results tab > Columns subtab, add the following fields:

• Name
  
• Summary Type = Group
• Opportunity : Actual Close
  
• Summary Type = Minimum
• Formula (Currency)
  
• Summary Type = Minimum
• Formula = min(to_char(substr({opportunity.projectedamount},1,3900))) keep(dense_rank first order by{opportunity.closedate})
  

5. Click Save & Run.