|
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 |
|