You need to sign in to do that
Don't have an account?

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)
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)
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.
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