• Meersadiqali Salimani
  • NEWBIE
  • 15 Points
  • Member since 2018
  • Manager Sales Operations
  • Pole to Win

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
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
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