Running sum

Returns the sum of the values in a list adding the current value to the preceding values. The calculation can restart based on attributes identified in the parameter settings.

Syntax

RunningSum<BreakBy = {}, SortBy = ()>(Argument)

• BreakBy is the parameter that sets the attribute designating where the calculation restarts.

• SortBy is the parameter that sets the attribute or metric by which the data is sorted.

• Argument is a metric representing the list of values.

For additional information on and an example of this function, refer to the MicroStrategy Functions Reference.