function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Meersadiqali SalimaniMeersadiqali Salimani 

Need help to optimize this formula --error "Compiled formula is too big to execute (5,241 characters). Maximum size is 5,000 characters"

Hi All,
I have a similar issues where am getting this error "Compiled formula is too big to execute (5,241 characters). Maximum size is 5,000 characters"

below is the formula am using and please note "Realization_Month__c" is a formula Text field.

IF(AND(Opportunity_Probability__c = 1,OR(Realization_Month__c = "Jan - 2017",Realization_Month__c = "Feb - 2017",Realization_Month__c = "Mar - 2017",Realization_Month__c = "Apr - 2017",Realization_Month__c = "May - 2017",Realization_Month__c = "Jun - 2017",Realization_Month__c = "July - 2017",Realization_Month__c = "Aug - 2017",Realization_Month__c = "Sep - 2017",Realization_Month__c = "Oct - 2017",Realization_Month__c = "Nov - 2017",Realization_Month__c = "Dec - 2017")), Amount_Finance__c, IF( Opportunity_Probability__c = 1,  Amount__c , 0))

pls can someone help he optimize this formula. 

Thanks
Meer
Best Answer chosen by Meersadiqali Salimani
Roman RiabenskyiRoman Riabenskyi
Oh, excuse me, this variant is correct:
IF( AND(Opportunity_Probability__c = 1, CONTAINS(Realization_Month__c, "2017")), Amount_Finance__c, IF(Opportunity_Probability__c = 1,  Amount__c , 0))

All Answers

Roman RiabenskyiRoman Riabenskyi
Your Realization_Month__c field has the same 2017 year. 
So you can try this:
IF( AND(Opportunity_Probability__c = 1, CONTAINS(Realization_Month__c, "2017"), Amount_Finance__c, IF(Opportunity_Probability__c = 1,  Amount__c , 0)))
Roman RiabenskyiRoman Riabenskyi
Oh, excuse me, this variant is correct:
IF( AND(Opportunity_Probability__c = 1, CONTAINS(Realization_Month__c, "2017")), Amount_Finance__c, IF(Opportunity_Probability__c = 1,  Amount__c , 0))
This was selected as the best answer
Meersadiqali SalimaniMeersadiqali Salimani
Brill! this works ,,Thanks Roman! Cheers