I want the commission to apply to my price,
If the first field is blank ISBLANK(TEXT(PiCKLIST) , then apply the BLANKVALUE( TEXT( Opportunity.Marketer_OPP_Year__c ), TEXT(Opportunity.Account.Marketer__c)),
"A",1,
"B",0.70,
"C",0.70,
"D",0.70,
"E",0.60,
0
)
Of course, if it s not blank , the followiing logic apply
"A",1,
"B",0.70,
"C",0.70,
"D",0.70,
"E",0.60,
UnitPrice *
CASE(
ISBLANK(TEXT(PiCKLIST),
BLANKVALUE( TEXT( Opportunity.Marketer_OPP_Year__c ), TEXT(Opportunity.Account.Marketer__c)),
"A",1,
"B",0.70,
"C",0.70,
"D",0.70,
"E",0.60,
0
)
2 respuestas
