cumsum(n: number) 🡒 number, process
Returns the cumulative sum of the numbers
n according to the specified ordering. The group is optional. When the group is specified, it is used to perform a local cumulative sum for each group.
table T = with [| as N, as G |] [| 4, "b" |] [| 3, "a" |] [| 2, "a" |] [| 1, "a" |] T.A = cumsum(T.N) sort T.N T.B = cumsum(T.N) by T.G sort T.N show table "" a1c3 with T.N T.G T.A T.B
While this process is part of the standard library, it could also be manually redefined with a user-defined process:
def process myCumsum(n : number) with keep sum = 0 sum = sum + n return sum