Case 1: The leading period is the first period of the year
The first period is kept unchanged, while subsequent periodic data is obtained by subtracting the previous period YTD from current period YTD.
For example, January is the first period of the year and the input file contains January, February, and March data. The row labeled YTD represents the data from the input file, and the row labeled Periodic represents the data as it will be loaded into the table.
| January | February | March | |
|---|---|---|---|
| YTD | 10 | 21 | 33 |
| Periodic | 10 | 11 | 12 |
- January=10
- February=21-10=11
- March=33-21=12