Custom Summary Formulas for Report Calculations

B.

Custom summary formulas support calculations on custom formula fields Apply calculations only to summary rows can be used to calculate the summaries on numerical fields of summary and matrix reports 3900 chars per formula 5 per report Applies calc to only summary rows Custom formula fields are - Read only on record detail pages Not visible on edit pages - Are supported on std and custom objects Do not update last modified field Can reference custom/std / other formula fields Cannot reference themselves - Cannot be deleted if they are referred in formulas Not searchable via sidebar / advanced search Not included in data export - Not available for lead conversion Not available in Offline edition / connect for outlook Are automatically calculated - Cross object formula up to 5 levels.

The statement "Custom Summary Formulas can run calculations on report calculations" is true.

Custom Summary Formulas allow Salesforce Lightning Experience administrators to add new calculations to report summaries, which can be based on other summary fields or standard report fields. Custom Summary Formulas can be used to perform calculations on the summarized data that is already displayed in a report, such as calculating the percentage of total for a given value or calculating the difference between two summary fields.

For example, let's say you have a report that displays the total sales for each sales representative, and you want to calculate the percentage of total sales for each representative. You can create a Custom Summary Formula that divides each sales representative's total sales by the total sales for all representatives, and then multiply by 100 to get the percentage.

Custom Summary Formulas can be created by navigating to the report builder, clicking on the "Add Formula" button in the "Custom Summary Formulas" section, and then defining the formula using the formula builder.

Overall, Custom Summary Formulas provide a powerful tool for creating custom calculations in reports that can help you gain insights and make data-driven decisions.