This article describes Rolling Value Formula variables, which allow convenient grouping of prior values as described below. The Rolling Value Formula can be applied to Product, Portfolio, or Corporate variables.
Rolling Value Formula
The Rolling Value Formula resides on the Formula Builder within the Formula Editor. It is activated after clicking the blue circled icons in the numbered sequence displayed below.
The Rolling Value Formula requires four input values
- Operator
- Operand
- Number of Points
- Frequency
Operator
The Operator drop-down box identifies the mathematical function that will be applied to prior values ending with the value corresponding to Time Index T. Eligible mathematical functions include Average, Minimum, Maximum, Median, and Sum as displayed below.
Operand
The Operand drop-down box identifies eligible Product Variables where the Operator will apply.
Number of Points
The Number of Points identifies the prior number of values ending with the value corresponding to Time Index T that will be included in the Operator function within the Operand field. In the example below, twelve prior values ending at Time Index T from the 1 Year Term Additional DB Per Policy field will be summed.
Frequency
The Frequency drop-down box allows the end-user to select the periodic frequency of prior data values. Eligible options include Monthly, Quarterly, Semiannual, or Annual frequencies. In the example below, the Rolling Value Formula will calculate the rolling sum of the prior twelve monthly values ending at Time Index T from the 1 Year Term Additional DB Per Policy field.
Example
In the example below, the Rolling Value formula in column D equals the twelve month rolling sum of values in Column C beginning with Time Index 11. Note that for Time Index <= 10, this same Rolling Value formula equals the cumulative sum through Time Index = T.