Skip to main content
Topics#Data ManagementQuestion de Salesforce Bot
Salesforce Bot (Endeavor) a posé une question dans #Data Management
1 sept. 2015, 18:46

Formula #Error! when CAGR rate is left blank

We were able to calculte CAGR rates using the formula below. When the Revenue fields are left blank we get an #.Error! is there any way around that?

 

Formula:

 

EXP( (1/1) * LN( (CAGR_Last_Year_Rev_USD__c / CAGR_2_Years_Ago_Rev_USD__c ) ) ) - 1

 

(CAGR_2_Years_Ago_Rev_USD__c is the Revenue 2 years ago field)
4 réponses
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    1 sept. 2015, 19:00

    Try this variant - 

    IF(
        OR(
            ISBLANK(CAGR_Last_Year_Rev_USD__c),
            ISBLANK(CAGR_2_Years_Ago_Rev_USD__c),
            CAGR_Last_Year_Rev_USD__c = 0,
            CAGR_2_Years_Ago_Rev_USD__c = 0
        ),
        NULL,
        EXP( (1/1) * LN( (CAGR_Last_Year_Rev_USD__c / CAGR_2_Years_Ago_Rev_USD__c ) ) ) - 1
    )
Rédiger une réponse...
0/9000