Examkin

Question

Difficulty: MediumSummary and Row-Level Report Formulas

A sales operations analyst at Cloud Kicks requires a Salesforce report that evaluates a partner commission amount for each individual Opportunity record by multiplying the custom currency field AmountAmount by the custom percentage field Commission_Rate_cCommission\_Rate\__c. The report must also display the total combined commission aggregated at the Opportunity Owner grouping level. Which solution should the Salesforce administrator implement to meet this requirement?

  1. Add a row-level formula column to the report that multiplies Amount by Commission Rate, and display the Sum aggregate at summary levels.Answer
  2. B
    Add a summary formula to the report using PARENTGROUPVAL to compute the multiplication of Amount by Commission Rate for each individual detail row.
  3. C
    Create a roll-up summary field on the Account object to calculate the total commission across linked Opportunities related via a standard lookup relationship.
  4. D
    Add a summary formula to the report that evaluates the row expression Amount multiplied by Commission Rate without defining a grouping level.

Answer

The administrator should add a row-level formula column to the report that multiplies AmountAmount by Commission_Rate_cCommission\_Rate\__c, and set the column summary aggregation to Sum.
Row-level formulas in Salesforce reports calculate values for each record row individually. Once defined, the resulting values can be summed, averaged, or otherwise aggregated across grouping levels such as Opportunity Owner.

Step-by-Step Solution

1
Identify the evaluation granularity required for the calculation.
The calculation must run for every individual Opportunity record row before summarizing.
When math logic needs to execute at the individual record level in a report, a row-level formula must be used rather than a summary formula.
2
Define the formula expression in the report builder.
Create a row-level formula column with the expression Amount×Commission_Rate_cAmount \times Commission\_Rate\__c.
Row-level formulas allow referencing individual field values per record row.
3
Configure report aggregation settings for the newly created formula column.
Enable the 'Sum' aggregation option on the row-level formula column.
Row-level formulas can be aggregated automatically at higher grouping levels like Opportunity Owner.

Key Concept

Row-Level Formulas vs. Summary Formulas
Rate this question

Topics

Summary and Row-Level Report Formulas

More questions from this topic