Calculate a running total for a table

[Kenny]

A Running total is a sequence of values that equate to partial sums from a set of data.
For example, you have an array of numbers you want to add together, but want the total of the current number + all the numbers before as you're iterating through your array.

You'll most likely need to collect your data and perform this inside a JS transformer before returning it into your table column:

let my_array = [1, 2, 3, 4] 
let starting_number = 10 
let temp_num = starting_number

let final = my_array.map(value => temp_num += value) 
//iterating through your array: temp_num = 10, value = 1
//starting: 10 + 1 = 11
//next: 11(taken from the previous) + 2 = 13
//next: 13(taken from the previous) + 3 = 16
//next: 116(taken from the previous) + 4 = 20

return final // [11, 13, 16, 20]

Inserting your data into your table:

1. Select your column
2. Insert your transformer name into the Value of your column
3. Reference your array-index by using the magic variable i