SF-Admin Data and Analytics Management Practice Question
Universal Containers' administrator is asked to build a report that shows only Opportunities whose Amount is greater than $100,000. The administrator must ensure that the filter uses the Amount field, which is a currency field. Which report filter option should the administrator use?
⚠ Common exam trap
The trap here is assuming that a custom formula field or bucket field is required for numeric comparisons, when standard filters already support operators like 'greater than' on currency fields.
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
✓
Use a standard filter with the operator 'greater than' and enter 100000.
The correct approach is to use a standard report filter with the 'greater than' operator on the Amount field. Salesforce reports natively support numeric and currency filters, so no custom fields or cross filters are needed. This keeps the report simple, maintainable, and accurate for the business requirement.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use a cross filter to include only Opportunities where Amount > 100000.
Why it's wrong here
Cross filters are used to filter a report based on related records, such as 'Opportunities with Products' or 'Accounts with Opportunities'. They cannot filter on a field value of the same object. Using a cross filter here would not allow the administrator to specify a numeric threshold on the Amount field, so it fails the requirement.
- ✗
Add a bucket field on Amount with ranges, then filter for the range above 100000.
Why it's wrong here
Bucket fields group values into ranges for reporting, but they are not designed for precise numeric filtering. A bucket field would create categories like '0-100k' and '100k+', which might include values exactly at 100000 depending on configuration. The requirement is 'greater than', so a bucket field is imprecise and not the correct tool.
- ✗
Create a custom formula field on Opportunity that returns TRUE when Amount > 100000, then filter on that field.
Why it's wrong here
While a formula field could work, it adds unnecessary complexity and maintenance. The requirement is a simple numeric filter on a standard currency field, which Salesforce reports already support natively. Creating a custom formula field would require a field creation, a deployment, and would not be the recommended approach for a straightforward threshold filter.
- ✓
Use a standard filter with the operator 'greater than' and enter 100000.
Why this is correct
A standard filter in Salesforce reports supports numeric operators such as 'greater than' for currency fields. Entering 100000 correctly filters Opportunities with Amount above that value. This is the simplest and most direct way to meet the requirement, and it works in both Lightning and Classic report builders without needing custom formulas or cross filters.
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.