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