Skip to main content
Topics#Reports & DashboardsPregunta de Marisa Grimes
Marisa Grimes ha preguntado en #Reports & Dashboards
15 dic 2017, 15:25

#Error! - Need help with Formula

I want to show % increase or decrease for sales - Issue getting an error message because SalesVision_c__ContactSalesAssets__c.SalesVision_c__ytd_gross_sales__c:SUM is zero.  I know need to add IF statement just can't figure it out.

 

(SalesVision_c__ContactSalesAssets__c.SalesVision_c__ytd_gross_sales__c:SUM

 

-

 

SalesVision_c__ContactSalesAssets__c.SalesVision_c__prev_year_gross_sales__c:SUM)

 

/

 

SalesVision_c__ContactSalesAssets__c.SalesVision_c__ytd_gross_sales__c:SUM
3 respuestas
  1. Jeff May
    15 dic 2017, 15:29
    You have to check that the SalesVision_c__ContactSalesAssets__c.SalesVision_c__ytd_gross_sales__c:SUM is not zero (you can't divide by zero).

     

    I usually do this by adding and IF to the formula:

     

    IF(SalesVision_c__ContactSalesAssets__c.SalesVision_c__ytd_gross_sales__c:SUM = 0, 0, 

     

    <insert your formula here>

     

    )
Escribir una respuesta...
0/9000