Hello, I'm trying to build a lead scoring formula based on category. I have analysed my historic data and was able to give a score to category based on how viable it is to convert.I've create the below case formula but am getting the error: Compiled formula is too big to execute (77,895 characters). Maximum size is 5,000 charactersCASE(Category__c,'Animal-Related',6,'Arts, Culture and Humanities',8,'Civil Rights, Social Action, Advocacy',3,'Community Improvement, Capacity Building',6,'Crime, Legal-Related',7,'Diseases, Disorders, Medical Disciplines',6,'Educational Institutions and Related Activities',9,'Employment, Job-Related',6,'Environmental Quality,Protection and Beautification',7,'Food, Agriculture and Nutrition',5,'Health ? General and Rehabilitative',7,'Housing, Shelter',6,'Human Services ? Multipurpose and Other',10,'International, Foreign Affairs and National Security',6,'Medical Research',4,'Mental Health, Crisis Intervention',5,'Mutual/Membership Benefit Organizations, Other',2,'Philanthropy, Voluntarism and Grantmaking Foundations',7,'Public Safety, Disaster Preparedness and Relief',4,'Public, Society Benefit ? Multipurpose and Other',8,'Recreation, Sports, Leisure, Athletics',8,'Religion-Related, Spiritual Development',6,'Science and Technology Research Institutes, Services',2,'Social Science Research Institutes, Services',4,'Unknown',7,'Youth Development',8,1)Looking for help on how I can shorten it.Thanks,
Hi Wayne,I am able to save the above given formula in my developer org and also the total characters were only around 1050. can you try to create a new formula and check on it.If this solution helps, Please mark it as best answer.Thanks,
If this solution helps, Please mark it as best answer.Thanks,
