1. SuiteAnalytics
  2. Reports
  3. Report Customization
  4. Adding, Removing, or Reordering Report Columns
  5. Adding Time-Based Comparison Columns to Reports
  6. Steps for Adding Comparison Column Formula Fields to Reports

Steps for Adding Comparison Column Formula Fields to Reports

Use the steps in the following procedure to add comparison column formula fields to a report.

To add a comparison column formula field to a report:

  1. Add two comparison columns to a report, each with a different Alternate Date Range or Alternate Period Range. See Steps for Adding Alternate Date Range Columns to Reports for details.

  2. In the Add Fields pane, click Add Formula Field.

  3. In the Formula Type field, select a formula to calculate values in the column.

  4. In the X and Y fields, select the comparison columns from step 1 to use as X and Y in the formula.

  5. If needed, check the Add Grand Total box to add formula column grand totals in subtotal rows.

  6. If you want the grand totals to be the sum of the formula column values, clear the Apply Formula to Grand Total box.

  7. Click Save.

For more information, see Adding Formula Fields to Reports.

Related Topics

General Notices