Skip to main content
Topics#Reports & DashboardsQuestion de Violeta Roshka
Violeta Roshka (Salesloft) a posé une question dans #Reports & Dashboards
2 déc. 2019, 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 réponses
  1. Steve Molis (You Owe Me a Beer, Inc.)
    2 déc. 2019, 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))
    )

     

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