I am trying to achieve a number field with the following but my formula won't work
-- If the account is own by Picklist (AgencyA__C) , nothing happen
--If the account is own by Picklist ( AgencyB, C, D,E) ,remove 30%
Revenue__c *
CASE( Agencies__c ,"AgencyA", 1,
0.70)
Thanks in advance for your input :)
3 respostas
Like this:
Revenue__c *
CASE(Agencies__c,
"AgencyA",1,
"AgencyB",0.70,
"AgencyC",0.70,
"AgencyD",0.70,
"AgencyE",0.70,
0
)
