Running Total (Sum, Average, Median, etc)

I think there’s a way to do this more efficiently by using an index-lookup approach rather than a find approach.

Make a column called Order that converts your datetime objects into a unique integer. Then Running Total formula can just be thisRow.Value + thisTable.Sort(true, Order).Nth(thisRow.Order - 1).Value

2 Likes