Orange polygon containing a stick figure running.

Running Total Tool

Version:
2021.2
Last modified: July 08, 2021

One Tool Example

Running Total has a One Tool Example. Visit Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer.

Use Running Total to calculate 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 Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.