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 sums, averages, counts, etc. Custom summary formulas can use functions such as PREVGROUPVAL which returns the value of a field from the previous row at the same grouping level. By using a custom summary formula with the PREVGROUPVAL function, an administrator can create a report to calculate the year-over-year change in the dollar amount of a company's opportunities by subtracting the amount from the previous year from the amount from the current year and dividing by the amount from the previous year. References: https://help.salesforce.com/s/articleView?id=sf.reports_builder_summary_formulas.htm&type=5 https://help.salesforce.com/s/articleView?id=sf.reports_builder_functions.htm&type=5