Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Aruna Dhavaleswarapu 4Aruna Dhavaleswarapu 4 

For the given formula in the formula field ,how can we write more effectively to avoid error "compiled formula is too big to execute"

IF(Spot_Business_Project__c,
   IF(MONTH(CloseDate)<10,
     IF(End_Date_of_Spot_Business_or_Project__c <= DATE(YEAR(CloseDate),9,30),
      Cabot_Incremental_Volume_Annualized_Y1__c,
       ((DATE(YEAR(CloseDate),9,30) - CloseDate) / (End_Date_of_Spot_Business_or_Project__c - CloseDate)) *  Cabot_Incremental_Volume_Annualized_Y1__c),
    IF(End_Date_of_Spot_Business_or_Project__c <= DATE(YEAR(CloseDate)+1,9,30),
       Cabot_Incremental_Volume_Annualized_Y1__c,
       ((DATE(YEAR(CloseDate)+1,9,30) - CloseDate) / (End_Date_of_Spot_Business_or_Project__c - CloseDate)) *  Cabot_Incremental_Volume_Annualized_Y1__c)), 
     
Cabot_Incremental_Volume_Annualized_Y1__c * Fiscal_Year_Factor__c)
Jainam ContractorJainam Contractor
Hi Aruna,

Can you please let me know what you are trying to build using this formula. Something like the use case for the same.

Thanks,
Jainam Contractor.
Aruna Dhavaleswarapu 4Aruna Dhavaleswarapu 4

As per business requirement, we are proportionating the balance of day between close date to fiscal year end against close date to the end of spot business date to calculate spot volume for fiscal year 1.  However, if the end of spot business date is within fiscal year end, 100% will be recognized. The fiscal year is calculated based on close date, as our fiscal starts from October which drives me to a situation that I look for the month of close date and calculate the formula accordingly.

Thank you Jainam