Time Range Start Period That is relative to current time period

edited July 2023 in Modeling Ideas


Time ranges require a fixed start period


Enable time range start to be setup relative to a specific period such the current time period. Also would be good if you can set up the start period with an offset. E.g. start period is current period minus 3 years.

What occurs in several of our models as that when we update the current year calendar, we have to update the time ranges as well. As the time ranges are generally relative to the current year.

For example, we would have the following types of time ranges:

  • Forecast Period Time Range. This would be setup to have a start period = current time period
  • Actual Period Time Range. This could be setup to have a start period = current time minus a fixed number of years. E.g. current period minus 2 years.

2 votes

New · Last Updated


Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!