Skip to main content The new Salesforce certifications experience is live! Visit Trailhead Academy to explore your new certifications homepage.
We have the following formula that we are trying to save and we are recieving the error that that the Compiled Formula is too big to execute (5,564 characters). Maximum size is 5,000 characters:

 

 

IF (

Bookings_Override_True__c = TRUE, TRUE,

IF(

Bookings_Override_False__c = TRUE, FALSE,

IF(

AND( Opportunity_Record_Type__c = 'Amendment',

OR(Line_Level_Detail__c = 'Customer Credit',

Line_Level_Detail__c = 'Services')), FALSE,

IF(

AND(Opportunity_Record_Type__c = 'Amendment',

OR(Line_Level_Detail__c <> 'Customer Credit',

Line_Level_Detail__c <> 'Services'), Commissionable__c = TRUE), TRUE,

IF(

AND(Opportunity_Record_Type__c = 'Amendment',

OR(Line_Level_Detail__c <> 'Customer Credit',

Line_Level_Detail__c <> 'Services'), Commissionable__c = FALSE), FALSE,

IF(

AND(Opportunity_Record_Type__c <> 'Amendment', Bookings_Override_False__c = FALSE, Bookings_Override_True__c = FALSE,

Line_Level_Detail__c = 'Services'), TRUE,

IF(

AND(Opportunity_Record_Type__c <> 'Amendment', Bookings_Override_False__c = FALSE, Bookings_Override_True__c = FALSE,

Line_Level_Detail__c <> 'Services', Line_Level_Type__c = 'Removed Product'), TRUE,

IF(

AND( Opportunity.Year_1_Term__c = 12, Opportunity.Year_2_Term__c = 12, QuoteLineYear__c = 'Year 1'), TRUE,

IF(

AND( Opportunity.Year_1_Term__c <= 12, ISNULL( Opportunity.Year_2_Term__c ), Year_Hidden__c = 'Year 1'), true,

IF(

AND( Opportunity.Year_1_Term__c < 12, Opportunity.Year_2_Term__c = 12, Year_Hidden__c = 'Year 2'), true,

false )

)

)

)

)

)

)

)

)

)

 

We are trying to determine if there is something we can do to possibly combine some statements in order to help shrink the compile size.

 

Any suggestions are apprecaited....
3 answers
Loading
0/9000