Table of Contents

Running Total

Description

Sum of a set of numbers up to a certain point.

Calculation Editor

Options

Input Parameter Values Input Values
Column to group by Column (Optional)

Input

Input Input Values Required
Input 1 Column or Literal

Remarks

  • If Column to group by is left blank and the report has no groupings, the running total is calculated based on the report's current sort order, if one exists.
  • If Column to group by is left blank and the report has groupings, the lowest grouping level is automatically used as the Column to group by.
  • If a column is specified for Column to group by, the running total resets and recalculates within each distinct value of that column.
  • Sort order affects all running total calculations, as it determines the sequence in which values are accumulated.

Example

  1. Input: Gross Amount (Respective Records: 20, 15, 45)
  2. Quick Calculations > Math > Running Total
  3. Output: Running Total (Respective Records: 20, 35, 80)