Case 2: The leading period is not the first period of the year
The first periodic data is obtained by subtracting all the previous periodic data in the database from the first YTD data in the input file. Subsequent periodic data is obtained similar to Case 1.
For example, January is the first period of the year and the input file contains April, May, and June YTD data, while the database FinLoc/FinPer table contains January, February, and March data.
| Database | January | February | March |
|---|---|---|---|
| Finloc (Periodic) | 10 | 11 | 12 |
| April | May | June | |
|---|---|---|---|
| YTD | 46 | 60 | 75 |
| Periodic | 13 | 14 | 15 |
- April periodic = 46-10-11-12=13
- May periodic = 60-46=14
- June periodic =75-60=15