Wednesday, February 22, 2017

Compiled formula is too big to execute (6,581 characters). Maximum size is 5,000 characters


Compiled formula is too big to execute (6,581 characters). Maximum size is 5,000 characters

Face the issue when compiling this formula :
IF (Country_Code__c ='GB' || Country_Code__c ='IE' || Country_Code__c ='ZA' || Country_Code__c ='KE' || Country_Code__c ='MA' || Country_Code__c ='TZ' || Codes__c ='BH' || Country_Code__c ='OM' || Country_Code__c ='AE' || Country_Code__c ='QA' || Country_Code__c ='SA','EMEA_REGION',null )
Requirement if the country field fall into certain code it will be labelled as 'EMEA_REGION' .

The formula is very simple but it still throws the exception because Country_Code__c is the formula field itself and it depend on how many times it being called.In this case,Country_Code__c is being called 11 so these will be pulled in formula compilation.

The issue can be solved by reducing the calling;
IF( CONTAINS("GB:IE:ZA:KE:MA:TZ:BH:OM:AE:QA:SA",Country_Code__c),"EMEA_REGION",null)
Also this is how we can check multiple value.

No comments:

Post a Comment