function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Mayank Raj 22Mayank Raj 22 

Can someone help me with this character count Issue for a formula field.

IF( Format__c = 'qw ert',
    CASE(
        IF(INCLUDES(Local__r.XYZ__r.ABC__c, 'ABC 10'),'1','')+
        IF(INCLUDES(Local__r.XYZ__r.ABC__c, 'New Vision'),'2','')+
        IF(INCLUDES(Local__r.XYZ__r.ABC__c, 'ABC 10+'),'3','')+
        IF(INCLUDES(Front__r.ABC__c, 'ABC 10'),'4','')+
        IF(INCLUDES(Front__r.ABC__c, 'New Vision'),'5','')+
        IF(INCLUDES(Front__r.ABC__c, 'ABC 10+'),'6',''),
            '25','New Vision',
            '125','New Vision',
            '1235','New Vision',
            '245','New Vision',
            '2456','New Vision',
            '145','ABC 10',
            '1345','ABC 10',
            '1246','ABC 10',
            '1456','ABC 10',
            '1245','New Vision;ABC 10',
            '12345','New Vision;ABC 10',
            '12456','New Vision;ABC 10',
            '146','ABC 10;ABC 10+',
            '1346','ABC 10;ABC 10+',
            '13456','ABC 10;ABC 10+',
            '12346','New Vision;ABC 10;ABC 10+',
            '123456','New Vision;ABC 10;ABC 10+',
    NULL),
NULL)
The above formula gives an error stating " Compiled formula is too big to execute". If I check it using external tool, the count comes down to way within the character limit. Local__r.XYZ__r.ABC__c as well as Front__r.ABC__c points to a Multi Select picklist field. 
Saifullah SaifiSaifullah Saifi
https://resources.docs.salesforce.com/204/latest/en-us/sfdc/pdf/salesforce_formula_size_tipsheet.pdf
This sheet will help you to reduce the size.
Maximum number of characters: 3,900 characters • Maximum formula size when saved: 4,000 bytes