Salesforce Classic报表：能否用自定义汇总公式计算营收差值？

Absolutely! You can absolutely calculate the difference between two revenue fields (like Jan FY2018 and Jan FY2019 Revenue) using a Custom Summary Formula in Salesforce Classic Reports—this works perfectly for calculating differences at summary levels (e.g., group totals, grand totals). If you need the difference on every detail row, there's a slightly different approach we'll cover too.

Step-by-Step: Using Custom Summary Formula (Summary/Grand Total Level) #

Follow these steps to add the difference calculation at a summary or grand total level:

• Open your target Salesforce Classic Report and switch to Edit mode.
• Scroll to the bottom of your report (or locate the group summary section if you've grouped your data). Click the dropdown menu next to the existing summary fields and select Add Summary Formula.
• In the formula setup window:
  1. Give your formula a clear name (e.g., Jan FY2019 vs FY2018 Revenue Gap) and optional description.
  2. Under Format, select Currency (match the format of your revenue fields) and set the decimal places to your preference.
  3. In the Summary Level dropdown, choose where you want this formula to apply—either Grand Total for the entire report's total difference, or a specific group level (e.g., Account Name if you're grouping by accounts).
  4. In the Formula editor, build your calculation. Use the Insert Field button to select your revenue fields, which will auto-wrap them in the appropriate aggregate function (like SUM()). For example:

     SUM(Jan_FY2019_Revenue__c) - SUM(Jan_FY2018_Revenue__c)
     

  5. Click Check Syntax to verify your formula is error-free, then hit OK.
• Save your report, and you'll now see the calculated difference in your summary/grand total section.

Bonus: Calculating Differences on Detail Rows #

If you need to show the revenue difference on every individual row of your report, use a Custom Formula Field instead (not a summary formula):

• In report edit mode, go to the Columns section and click Add Formula.
• Name your field, set the format to Currency, then enter a simple subtraction formula like:

  Jan_FY2019_Revenue__c - Jan_FY2018_Revenue__c
  

• Validate the formula, save it, and your detail rows will now display the per-record revenue difference.

内容的提问来源于stack exchange，提问作者Dileep Katari