|
The following table shows the offset to use for common tasks when using Spread Grouping functions (GAVG, GSUM, etc...):
Grouping: "M" - Monthly
| GroupOffset |
Description |
Month(Report dates of 1/1/02 thru 1/31/02) |
| -35 |
Three years ago |
Jan 1999 |
| -23 |
Two years ago |
Jan 2000 |
| -11 |
One year ago |
Jan 2001 |
| -10 |
Eleven months ago |
Feb 2001 |
| -9 |
Ten months ago |
Mar 2001 |
| -8 |
... |
Apr 2001 |
| -7 |
... |
May 2001 |
| -6 |
... |
June 2001 |
| -5 |
... |
July 2001 |
| -4 |
... |
Aug 2001 |
| -3 |
Four Months ago |
Sept 2001 |
| -2 |
Three Months ago |
Oct 2001 |
| -1 |
Two Months ago |
Nov 2001 |
| 0 |
Last Month |
Dec 2001 |
| 1 |
This Month |
Jan 2002 |
| 2 |
Next Month |
Feb 2002 |
| 3 |
Two Months ahead |
Mar 2002 |
| 13 |
One year ahead |
Jan 2003 |
| 25 |
Two years ahead |
Jan 2004 |
|