Running Total Tool
Tip
This tool has a One Tool Example. Visit Access Sample Workflows to learn how to access this and many other examples directly in Designer Cloud.
Use Running Total to calculate a cumulative sum per row in a dataset.
Row | Value | RunTot_Value |
---|---|---|
A | 10 | 10 |
B | 12 | 22 |
C | 4 | 26 |
It can also create sums of groups of rows and calculate the cumulative sums of multiple columns at the row or group level.
Row | Group | VALUE_1 | RunTot_VALUE_1 | VALUE_2 | RunTot_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
Select the Columns to Compute Running Total. New columns are added with a RunTot_ prefix to show running totals for each column selected.
Select the Columns to Group By (Optional).
Select how to sort your columns in the Sort By table. The row position of incoming data isn't preserved. Sort by column to return an accurate range.