CumulativeStdDev
The CumulativeStdDev function calculates the standard deviation of a column up to and including the current row value.
Syntax
CumulativeStdDev([Column])
Function Arguments:
- [Column] (required) - The column of numbers to evaluate the cumulative standard deviation.
Cumulative functions depend on the order of the given column. If you change the sorting you will change the result.
Example
CumulativeStdDev([Monthly Revenue])
A table contains the monthly revenue of a store. The CumulativeStdDev function can be used to find the standard deviation up to and including the current month.