Thanks in advance for the input
UnitPrice *
IF(
ISBLANK(TEXT( Marketer_Special_C__c ),
"A",1,
"B",0.70,
"C",0.70,
0
)
CASE(
BLANKVALUE( TEXT( Opportunity.Marketer_c ),
TEXT(Opportunity.Account.Marketer__c),
"A",1,
"B",0.70,
"C",0.70,
0
3 respuestas
Hi, Try this
UnitPrice * ( IF(TEXT(Marketer_Special_C__c) == "A", 1, IF(TEXT(Marketer_Special_C__c) == "B", 0.70, IF(TEXT(Marketer_Special_C__c) == "C", 0.70, 0) ) ) )
