The following table shows the offset to use for common tasks when using Spread Grouping functions (GAVG, GSUM, etc...):
Grouping: "YTBSD" - Year to Before Start Date
| Offset |
Description |
Dates(Report dates of 3/1/02 thru 3/31/02) |
| -1 |
Two years ago, YTD |
1/1/2000 - 2/29/2000 (leap year) |
| 0 |
One year ago, YTD |
1/1/2001 - 2/28/2001 |
| 1 |
Year to Date |
1/1/2002 - 2/28/2002 |
| 2 |
Next Year, YTD |
1/1/2003 - 2/28/2003 |