Narrow Search

Can't find what you need?
Contact Us

Reset Search
    Search Knowledge Base

Summarize Report Data with Formulas

« Go Back


Previous: Filter Operators

A formula is an algorithm that derives its value from other fields, expressions, or values. Custom summary formulas can contain 3900 or fewer characters. Custom summary formulas are available for summary, matrix, and joined reports. They can't be shared across multiple reports.

  1. In report builder, click Add Formula in the Fields pane.
  2. Enter a name for your formula as it will appear on the report. The label must be unique. Optionally, enter a description.
  3. From the Format drop-down list, select the appropriate data type for your formula based on the output of your calculation.
  4. From the Decimal Places drop-down, select the number of decimal places to display for currency, number, or percent data types. This setting is ignored for currency fields in multicurrency organizations. Instead, the Decimal Places for your currency setting apply.
  5. If you select None for Decimal Places, the effective values are:
    • For currency, displays up to 18 digits, with the default decimal-place precision for the currency
    • For percentages, displays up to 18 digits, with no decimal places
    • For numbers, displays up to 18 digits, without changing the decimal-place precision
  6. Set the Where will this formula be displayed? option. The formula calculation will be displayed in the report at the level you select. To display the formula calculation at every level, including the Grand Total, select All summary levels.
  7. Build your formula:
    • Select one of the fields listed in the Summary Fields drop-down list. This field's value is used in your formula.
    • Select the kind of summary type to use in your formula. This option is not available for Record Count
    • Click Operators to add operators to your formula.
    • Select the function category (All, Logical, Math, or Summary), choose the function you want to use in your formula, and click Insert.
    • Repeat these steps as necessary.
  8. Click Check Syntax to see if your formula contains errors. Errors are highlighted by the cursor.
  9. Click OK. Your formula isn't saved until you save the report.
Next: Print and export reports



Was this article helpful?



Please tell us how we can make this article more useful.

Characters Remaining: 255