Valid Advanced-Administrator Dumps shared by ExamDiscuss.com for Helping Passing Advanced-Administrator Exam! ExamDiscuss.com now offer the newest Advanced-Administrator exam dumps, the ExamDiscuss.com Advanced-Administrator exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com Advanced-Administrator dumps with Test Engine here:
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?
Correct Answer: D
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. References: 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