SF-Admin Configuration and Setup Practice Question
An administrator needs to create a field that calculates a commission percentage based on the Opportunity Amount. Which data type is required?
⚠ Common exam trap
Candidates sometimes suggest 'Automation' or 'Apex'. While possible, the simplest and most efficient way to calculate a value based on another field is using a Formula field.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Formula field
The Formula field data type is required to perform mathematical calculations based on other fields within the same object. By using a formula, the system dynamically updates the commission value whenever the underlying amount changes. This ensures data integrity and reduces the need for manual calculations or automation triggers, streamlining the sales process and improving the accuracy of financial reporting across the organization.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Roll-up Summary
Why it's wrong here
Roll-up Summary fields are used to aggregate data from related child records, such as calculating the sum of Opportunity Products on an Opportunity. They cannot perform calculations based on fields residing on the same object record, which is a fundamental requirement for calculating a simple commission percentage field.
- ✗
Currency field
Why it's wrong here
A Currency field is a static input field used to store monetary values entered by users. While it can store the result of a calculation, it cannot perform the calculation itself. The logic to compute the commission based on the Opportunity Amount must reside within a separate formula field.
- ✓
Formula field
Why this is correct
A Formula field allows the administrator to define a custom calculation using standard operators and functions. By referencing the Opportunity Amount, the formula can automatically determine the commission percentage, providing real-time financial data to sales teams without requiring additional user input or complex automated processes to maintain values.
- ✗
Percent field
Why it's wrong here
A Percent field is a numeric field formatted to display as a percentage, intended for user input or data loading. It does not contain the logic necessary to execute mathematical operations on other record fields, meaning it cannot derive its own value from the Opportunity Amount field automatically.
About these practice questions
This SF-Admin question is part of Courseiva's 202-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Salesforce exam blueprint
This SF-Admin practice question is part of Courseiva's free Salesforce certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SF-Admin exam.