Skip to main content
Topics#Reports & DashboardsQuestion de Jaideep Monga
Jaideep Monga a posé une question dans #Reports & Dashboards
6 sept. 2017, 13:48

Calculating win rate % based on Product count in Closed Won and Lost Opptys

I need to calculate the Win Rate % for the products in the Closed Won and Lost Opptys. Basically, the formula should look something like this:

 

# Products in WON Opptys / (# Products in WON Opptys + # Products in Closed Lost Opptys)

 

 
3 réponses
  1. Sunil Sarilla (M&G Investments)
    6 sept. 2017, 13:57
    Hi Jaideep,

     

    You will need to do the below

     

    Create a Rollup Summary Field on Opportunity Object and Rollup the Count of Opportunity Products

     

    Create a Formula field on the Opportunity Object and label this field as Count of Won Products and the formula will be

    IF(IsWon,
    Rollup_Field__c,
    0)

    Now Create a Matrix or Summary Report and Create a custom summary formula field on the reort

     

    format: percent and the formula will be

    FormulaField__c:SUM/
    Rollup_Field__c:SUM

    Click on Insert summary fields and select the Formula field and select SUM

     

     
Rédiger une réponse...
0/9000