Skip to main content
Topics#Reports & DashboardsVioleta Roshka の質問
Violeta Roshka (Salesloft) が「#Reports & Dashboards」で質問
2019年12月2日 14:38

report formula

Hi, I built a matrix report and a formula (PARENTGROUPVAL) to show the rate of disqualified opps. The result shows as Error in some cases because the total number of the grouping is 0. I was wondering if it's possible to edit the formula to get rid of Error in the report? report formula

 

User-added image
2 件の回答
  1. Steve Molis (You Owe Me a Beer, Inc.)
    2019年12月2日 16:12

    That is a "Divide by Zero" error, you'll need to add an escape/exit like this

    IF(PARENTGROUPVAL(RowCount, Opportunity.SDR_Created_override__c, Opportunity.First_Meeting_Date__c) = 0, NULL,
    (RowCount / 
    PARENTGROUPVAL(RowCount, Opportunity.SDR_Created_override__c, Opportunity.First_Meeting_Date__c))
    )

     

     
回答を記入...
0/9000