The following table shows the offset to use for common tasks when using Spread Grouping functions (GAVG, GSUM, etc...):
Grouping: "YTD" - Year to End Date
| Offset |
Description |
Dates(Report dates of 3/1/02 thru 3/31/02) |
| -1 |
Two years ago, YTD |
1/1/2000 - 3/31/2000 |
| 0 |
One years ago, YTD |
1/1/2001 - 3/31/2001 |
| 1 |
Year to Date |
1/1/2002 - 3/31/2002 |
| 2 |
Next Year, YTD |
1/1/2003 - 3/31/2003 |
Download Example Template: Help_YTD_Grouping.ss3 (Click here for download instructions)