Skip to main content

I'm sure there is a simple answer for this, that I'm overlooking.  When reviewing something with one of our Sales Reps she brought up that a sizable opportunity in her pipeline report is actually a split opportunity between her and 2 other people (50/25/25 split); however the full opportunity amount is showing on the report vs only the 25% she is credited for. It is a standard Opportunity report (not a split opportunity report). I'd like to be able to see split and regular opportunities on reports for our reps. I haven't been able to figure out how to build out a report that will show me both.  I've tried Cross Filter logic on a standard Opportunity report, but it won't let me have an "or" statement. I also tried creating a custom Report Type (opp - master (A), opp split - child (B)) but it wouldn't show me either or either.  If anyone can lead me in the right direction that would be awesome.   Thank you!  @Opportunity Split

답변 3개
  1. Michael Brown (Salesforce) Forum Ambassador
    2021년 12월 8일 오후 4:40

    Hi Michelle, 

     

    You should be able to just use the standard Opportunity Splits report type for this. For example, when I do this, I just see the split information:

     

    Hi Michelle, You should be able to just use the standard Opportunity Splits report type for this.

     

    There are a few key notes:

    • Make sure to include the Amount from the Split object, and not the Opportunity Amount in your report columns
    • Make sure to include a filter for Active splits only. It sounds like there is a default split created, in which you might see a split for the total opportunity amount, which was likely created by default once splits were enabled

    Thanks,

    Mikey