ExamGecko
Search Search Login
Home Home / Salesforce / Certified Advanced Administrator (CRT-211)
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

When should an administrator consider when using Person Accounts'
The administrator at Cloud Kicks needs to import a batch of person accounts into Salesforce. What tool should the administrator use?
Administrator has been tasked with creating a new custom field on the Account object called Government Der. The compliance department has determined that this field contains sensitive Information and needs to be encrypted using Classic Encryption. How will this impact users when reading, editing, or reporting on Accounts?
The sales manager at Cloud Kicks (CK) wants to make sure the accounts that CK serves are happy. One way they track this is by how many open cases an account has with CK. The sales manager asks CK's administrator to build a report to show Accounts with Open Cases. What report type would this be?
Ursa Major Solar has a junction object that connects Docs with Solar Panels. The administrator needs users to be able to see all the solar panels that a Dot is related to. Users already have access to the Bot and the Junction, but not the Solar Panel object. What access docs the user need to be able to see the solar panel records?
When configuring a change set, which two practices should an administrator adhere to in order to ensure a successful deployment to production? Choose 2 answers
DreamHouse Realty (DR) wants to ensure that its data is protected. There have been several recent attempts to phish employees. What should DR do to help ensure that the user that is logged in is the right user when the running user is trying to view reports and dashboards?
Ursa Major Solar allows its scientists to log new stars as they find them, but on occasion, they log the same star by mistake. The administrator wants scientists to be notified when a record is deleted and by whom, and to maintain their own discovery information. What automation solution should be used to send the notification?
An administrator has found a free app on the AppExchanged and would like to install it. Which three items should the administrator take to consideration before installed he managed package? Choose 3 answers
Cloud Kicks (CK) has an email parsing tool. CK wants to ensure that when certain field are updated, the Case Owner is notified by email. What should the administrator use to email the Case Owner?

Question 58 - Certified Advanced Administrator (CRT-211) discussion

Report
Export

An administrator is asked to create a report to calculate the year-over---year changed in the dollar amount of a company's opportunities.

What reporting tool should be used to complete this request?

A.
A row-level formula to compare amounts grouped by year.
Answers
A.
A row-level formula to compare amounts grouped by year.
B.
A joined report with two report blocks for each year
Answers
B.
A joined report with two report blocks for each year
C.
A custom summary formula with PARENTGROUPVAL function
Answers
C.
A custom summary formula with PARENTGROUPVAL function
D.
A custom summary formula with the PREVGROUPVAL function.
Answers
D.
A custom summary formula with the PREVGROUPVAL function.
Suggested answer: D

Explanation:

A custom summary formula is a formula that calculates values from summary fields in reports such as sum, average, min, max, etc. Custom summary formulas can use functions such as PREVGROUPVAL to compare values from different groups in reports. For example, to calculate the year-over-year change in dollar amount of opportunities, an administrator can create a custom summary formula that uses PREVGROUPVAL to compare the sum of amount from this year's group with the sum of amount from last year's group, and divide it by last year's sum of amount.

Reference: https://help.salesforce.com/s/articleView?id=sf.reports_builder_fields_summary_formulas.htm&type=5 https://help.salesforce.com/s/articleView?id=sf.reports_formulas_prevgroupval.htm&type=5

Show Answer
asked 23/09/2024
Simone Somacal
31 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms