Salesforce Certified Administrator · Free Practice Question Medium
Question 9
Sales Reps receive a 5% commission on all Opportunities that are closed/won. You need to add new fields on the Opportunity to calculate and show both the Commission Amount owed to the Sales Rep, along with the Remaining Amount that will go to the Company. What type of field can accommodate both of these values?
-
A
Formula field with a Return Type of Currency
-
B
Currency field
-
C
Number field
-
D
Text field
Reveal correct answer
Correct answer: A
Explanation
You would need to create formula fields to calculate both of these values. And since the values we are dealing with a currency values, the return type for these formula fields would need to be specified with a Return Type of Currency. This will present the values in the proper currency and formatting and will be dynamically derived, based on the value of the opportunity and the calculations contained within the formula. These types of formula fields are often requested for reporting purposes. Here are a lot of formula examples you can try out - https://help.salesforce.com/articleView?id=useful_advanced_formulas_commission.htm&type=0&language=en_US&release=206.13Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
