Challenge
Create a formula field,
Amount | Commission Percentage |
---|---|
>= 20,000 | 10% |
< 20,000 | 8% |
Create the following field on ```Opportunity```:
Field Type: Formula (Currency)
Field Label: Commission
Field Name: Commission
Description: Calculates the commission expected for a deal
Example Scenarios:
Scenario 1:
Input: Amount = 100,000
Result:Commission__c = 10,000
Explanation: 100,000 is greater than 20,000, therefore the commission is 10%. 10% of 100,000 is 10,000.
Scenario 2:
Input: Amount = 20,000
Result:Commission__c = 2,000
Explanation: 20,000 is equal to 20,000, therefore the commission is 10%. 10% of 20,000 is 2,000.
Scenario 3:
Input: Amount = 5,000
Result:Commission__c = 400
Explanation: 5,000 is less than 20,000, therefore the commission is 8%. 8% of 5,000 is 400.