Alternate Range Types
After you add a column to a report, you can select one of the following alternate range types:
-
Relative to report date
-
-
Defined in relation to the overall date range set for the report.
-
Changes when the overall report date range changes.
-
Most commonly used type.
-
Example: In December 2009, you add a column with an alternate date range of last month to a report and run it. It displays December 2009 data for most columns, and November 2009 data for the alternate date range column. When you change the report date range to January 2010, it displays January 2010 data for most columns and December 2009 data for the alternate date range column.
-
-
Relative to today's date
-
Defined in relation to the current date when the report is run
-
Does not change when the overall report date range changes.
-
This type is provided for backward compatibility with the alternate date range functionality available before Version 2010 Release 1.
-
Example: In December 2009, you add a column with an alternate date range of last month to a report and run it. It displays December 2009 data for most columns, and November 2009 data for the alternate date range column. When you change the report date range to January 2010, it displays January 2010 data for most columns and still displays November 2009 data for the alternate date range column.
-
For an alternate range that is “to date”, such as this fiscal year to date, you should select an alternate range type of Relative to today's date. If you define an alternate range type of Relative to report date, and choose an alternate range like this fiscal year to date, alternate date range column results are calculated as of the From date of the overall report range, and this column's comparison with other report columns is not useful.