Percent Formula
Formula --- If Opportunity name contain “2020” and Status = WON then the commission is 8%
Otherwise, the commission is 10%
Thank you
3 réponses
Hi Amin, the formula will be as below
IF(
AND(
CONTAINS(Name, '2020'),
TEXT(Status__c) = 'WON'
),
0.08,
0.1
)
I have assumed Status is a custom picklist, if Status is Stage Picklist field in Salesforce, the formula will be
IF(
AND(
CONTAINS(Name, '2020'),
TEXT(StageName) = 'WON'
),
0.08,
0.1
)
or Alternatively
IF(
AND(
CONTAINS(Name, '2020'),
IsWon
),
0.08,
0.1
)
