I am trying to create a formula field based on another formula field and I keep getting the error 'Error: Compiled formula is too big to execute (28,118 characters). Maximum size is 5,000 characters'. I've used CASE (below) - does anyone have any ideas?
Case((NGO_Region__c),"USA",13,"Canada",2,"UK & Ireland",7,"Nordic",1,"Japan",2,"Asia exc. Japan",0,"Australia & New Zealand",3,"South America",3,"Africa",4, null)
12 个回答
Give this a try: CASE(HQ_country__c,
"USA",13,
"Canada",2,
"UK", 7,
"Ireland", 7,
"Japan", 2,
"Australia", 3,
"New Zealand", 3,
"South Africa", 4,
"Botswana", 4,
"Malawi", 4,
"Mozambique", 4,
"Namibia", 4,
"Ghana", 4,
"Nigeria", 4,
"Zimbabwe", 4,
"Argentina", 3,
"Brazil", 3,
"Chile", 3,
"Colombia", 3,
"Peru", 3,
"Denmark", 1,
"Finland", 1,
"Iceland", 1,
"Norway", 1,
"Sweden", 1,
NULL)
