Skip to main content
Topics#Data ManagementPergunta de Salesforce Bot
Salesforce Bot (Endeavor) perguntou em #Data Management
28 de set. de 2015, 17:52

Formula #Error! when CAGR rate is left blank

I got some great help on my last CAGR question (https://success.salesforce.com/answers?id=9063000000159kM )now I have a slightly different one. When companies are selected to be in our portfolio we track how thier CAGR rates increase. Currently the formula doesn;t allow for that when there is no information priori so it Error's out.

 

Here's the Current Formula:

 

EXP( (1/ 

 

((YEAR(TODAY()) - YEAR(Application_Decision_Date__c)) - 1) 

 

) 

 

* LN( (CAGR_Last_Year_Rev_USD__c / Revenue_USD_At_Selection__c ) ) ) - 1 

 

Ideas?
1 resposta
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    28 de set. de 2015, 18:04

    Try this - 

    IF(
        OR(
            (YEAR(TODAY()) - YEAR(Application_Decision_Date__c)) = 1,
            ISBLANK(Revenue_USD_At_Selection__c),
            Revenue_USD_At_Selection__c = 0,
            (CAGR_Last_Year_Rev_USD__c / Revenue_USD_At_Selection__c) = 0
        ),
        NULL,
        EXP(
            (
                1 / ((YEAR(TODAY()) - YEAR(Application_Decision_Date__c)) - 1)
            ) * 
            LN(CAGR_Last_Year_Rev_USD__c / Revenue_USD_At_Selection__c) 
        ) - 1
    )
Escrever uma resposta...
0/9000