Fomula with 3 layers

Question

Hello everyone, my formula won't work ,''Error: Compiled formula is too big to execute '' i need help :) i want to add a layer to a formula

Thanks in advance for the input

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

)

Ajay Dubedi · Answer

Hi Amin,

If you're referencing information / creating info that has a lot of characters for the system to read (over 5,000 characters), this can happen.

These might help:

You also might need to use an Apex Trigger, instead.

I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.

Thanks,

Ajay Dubedi

Formulas