Astuce
Cet outil dispose d'un exemple d'outil unique. Consultez la page Accéder aux exemples de workflows pour savoir comment accéder à cet exemple et à de nombreux autres exemples directement dans 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 |
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.