Example: Running Total
Input Data
| Yield Curve Type | Period | Interpolated Yield | Amount |
|---|---|---|---|
| Yield Curve | 0 | –0.0001537 | 100.0000 |
| Yield Curve | 1 | 0.0043374 | 100.4337 |
| Yield Curve | 2 | 0.0088285 | 101.7735 |
| Yield Curve | 3 | 0.0096286 | 102.9165 |
| Yield Curve | 4 | 0.0104287 | 104.2372 |
| Yield Curve | 5 | 0.011203 | 105.7284 |
| Yield Curve | 6 | 0.0119945 | 107.4160 |
| Yield Curve | 7 | 0.012786 | 109.3009 |
| Yield Curve | 8 | 0.0135775 | 111.3924 |
| Yield Curve | 9 | 0.0143518 | 113.6835 |
| Yield Curve | 10 | 0.0151261 | 116.1983 |
| Yield Curve | 11 | 0.0159004 | 118.9495 |
| Yield Curve | 12 | 0.0166747 | 121.9507 |
| Yield Curve | 13 | 0.017449 | 125.2173 |
Configuration
| Rule | Description | Rule Type | State | Rule Grouping Fields | Rule Ordering Fields | Selection |
|---|---|---|---|---|---|---|
| R001 | Running Total | Running Total | Active |
| Line | Description | Value | Granularity | Term | Running Total |
|---|---|---|---|---|---|
| L001 | Running Total | Amount | Yield Curve Type | Period | Running Total |
Based on the configuration, the key figure to be aggregated for the running total is Amount. The system computes the total of all the data and stores it in the additional column Running Total.
Expected Result
| Yield Curve Type | Period | Interpolated Yield | Amount | Running Total |
|---|---|---|---|---|
| Yield Curve | 0 | –0.0001537 | 100.0000 | 100.0000 |
| Yield Curve | 1 | 0.0043374 | 100.4337 | 200.4337 |
| Yield Curve | 2 | 0.0088285 | 101.7735 | 302.2072 |
| Yield Curve | 3 | 0.0096286 | 102.9165 | 405.1237 |
| Yield Curve | 4 | 0.0104287 | 104.2372 | 509.3609 |
| Yield Curve | 5 | 0.011203 | 105.7284 | 615.0893 |
| Yield Curve | 6 | 0.0119945 | 107.4160 | 722.5053 |
| Yield Curve | 7 | 0.012786 | 109.3009 | 831.8062 |
| Yield Curve | 8 | 0.0135775 | 111.3924 | 943.1987 |
| Yield Curve | 9 | 0.0143518 | 113.6835 | 1056.8822 |
| Yield Curve | 10 | 0.0151261 | 116.1983 | 1173.0805 |
| Yield Curve | 11 | 0.0159004 | 118.9495 | 1292.0300 |
| Yield Curve | 12 | 0.0166747 | 121.9507 | 1413.9806 |
| Yield Curve | 13 | 0.017449 | 125.2173 | 1539.1980 |