Skip to main content

Hello,

I've just noticed that in a standard report Campaigns with Opportunities also Products are included so that the Record Count is referred to Products instead of opps.

How is that possible? Has something changed?

답변 3개
  1. 2024년 5월 16일 오후 7:15

    I am unaware of any change like that, I do see that Products are available in a standard Campaigns with Opportunities report, but that's not a Report Type that I use often, so I don't recall off the top of my head if they've always been there.  

     

    To get the count of Opportunity Records, I would use Tom Tobin's "Power of One" technique =>

     

    Tips & Tricks: "The Power of One" the Greatest Formula Ever Written*

    https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000A7RsPSAV

     

    Or use Opportunity_ID:UNIQUE 

     

    and filter the Report using Stage Change equals TRUE 

     

    Documentation

     

    Count Unique Values in Report Results

    https://help.salesforce.com/s/articleView?id=sf.reports_count_unique_values.htm&language=en_US&release=246.4.0&type=5

0/9000