Orange polygon containing a stick figure running.

Running Total Tool

Version:
Current
Last modified: May 11, 2020

The Running Total tool calculates a cumulative sum on a numeric field per record in a file.

RECORD VALUE RunningTotal_VALUE
A 10 10
B 12 22
C 4 26

It can also create sums of groups of records and calculate the cumulative sums of multiple fields at the record or group level.

Record Group VALUE_1 RunTotal_VALUE_1 VALUE_1 RunTotal_VALUE_2
A1 A 10 10 7 7
A2 A 5 15 3 10
B1 B 12 12 5 5
B2 B 8 20 1 6
C1 C 4 4 11 11
C2 C 2 6 9 20
D1 D 6 6 0 0

Configure the Tool

  1. Select the fields to Group By (Optional).
  2. Create Running Total: Select the numeric fields to create a running total. New columns are added with a RunTot_ prefix to show running totals for each column selected in the Create Running Total section.
Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.