+ Start a Discussion
Aravind RAravind R 

Compiled formula is too big to execute

I have a formula field "Solutions TAT" which is of 4500 compiled characters.

I have another formula field as below which is giving compiled formula is too big to execute error as I am referring "Solutions TAT" twice which is a big formula field:

IF( Solutions_TAT__c >  Target_Completion_Days_Solutions__c , 'RED'
 IF(Solutions_TAT__c < (Target_Completion_Days_Solutions__c * 0.7), 'GREEN',
'AMBER'

)

Please suggest some workaround to overcome this. Thanks in advance.
Best Answer chosen by Aravind R
anand k 11anand k 11
Hi Arvind,

Try using the formula in Solutions_TAT__c and use it in this formula to get the value that you want, or use a workflow with a field update to populate the field you are trying to work with.

Thanks
Anand

All Answers

anand k 11anand k 11
Hi Arvind,

Try using the formula in Solutions_TAT__c and use it in this formula to get the value that you want, or use a workflow with a field update to populate the field you are trying to work with.

Thanks
Anand
This was selected as the best answer
Fahad-AkhtarFahad-Akhtar
Your formula which is calling Solutions_TAT__c looks ok, You should try to reduce the formula in Solutions_TAT__c using "https://help.salesforce.com/help/pdfs/en/salesforce_formula_size_tipsheet.pdf", As anand mentioned using a workflow field update should also work in reducing the formula size as your are calling the same formula field twice.