Error: Compiled formula is too big to execute (5.242 characters). Maximum size is 5.000 characters
UnitPrice *
CASE(
BLANKVALUE(TEXT(Marketer_Special_c__c), BLANKVALUE( TEXT( Opportunity.Marketer_OPP__c ), TEXT(Opportunity.Account.Marketer__c))),
"Pi",1,
"PO",0.70,
"IL",0.70,
"OP",0.70,
"HZ",0.60,
"BC",0.70,
"AB",0.70,
0
)
6 respostas
Try using this one instead
CASE(Marketer_Special_c__c,
"Pi",1,
"PO",0.70,
"IL",0.70,
"OP",0.70,
"HZ",0.60,
"BC",0.70,
"AB",0.70,
CASE(Opportunity.Marketer_OPP__c,
"Pi",1,
"PO",0.70,
"IL",0.70,
"OP",0.70,
"HZ",0.60,
"BC",0.70,
"AB",0.70,
CASE(Opportunity.Account.Marketer__c,
"Pi",1,
"PO",0.70,
"IL",0.70,
"OP",0.70,
"HZ",0.60,
"BC",0.70,
"AB",0.70,
0)))
