The following table shows the offset to use for common tasks when using Spread Grouping functions (GAVG, GSUM, etc...):
Grouping: "Y" - Yearly
Offset |
Description |
Dates(Report dates of 1/1/02 thru 1/31/02) |
-1 |
Two years ago |
2000 (i.e. 1/1/2000 thru 12/31/2000) |
-0 |
One year ago |
2001 |
1 |
This year |
2002 |
2 |
Next year |
2003 |
|