You need to sign in to do that
Don't have an account?
Meersadiqali 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
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
IF( AND(Opportunity_Probability__c = 1, CONTAINS(Realization_Month__c, "2017")), Amount_Finance__c, IF(Opportunity_Probability__c = 1, Amount__c , 0))
All Answers
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)))
IF( AND(Opportunity_Probability__c = 1, CONTAINS(Realization_Month__c, "2017")), Amount_Finance__c, IF(Opportunity_Probability__c = 1, Amount__c , 0))