December 2019
Beginner
370 pages
8h 9m
English
There are two ranges of functions available that work in a very similar way to some of the quick options.
The first range is the RUNNING functions, including RUNNING_SUM, RUNNING_COUNT, and so on. These functions aggregate the results that are in cells in the current partition by starting with the first one and running along, updating the calculation and aggregating the results for each new cell. While the running sum is the most obvious example, and is one of the available quick calculations, it can sometimes be useful to use another running function to provide results. For instance, the RUNNING_MAX function is useful when keeping track of a record, as the function will update to the ...
Read now
Unlock full access