Editing forecasts and reforecasting

1. Editing generated forecasts

You can edit a forecast that was configured previously. To edit, click Home > Manage Measures to open the side pane and click on the edit icon near the forecast that needs to be edited.

Editing a forecast

i) Forecast period

You can update the forecast time frame. You may have chosen to forecast for the entire year and then decided to extend it to the following year, reduce the forecast duration to six months, or include a customized period. You can click on the calendar icon, then select and drag to adjust the forecast period.

Changing the forecast period

Notice how the forecast has been reduced to 9 months after updating the forecast period.

Reducing the forecast time period

ii) Reset/Reopen closed period

This option can be used to reset forecasted periods that were closed after actual data became available. Consider that the forecast from January 2024 to June 2025 has been closed, as shown below.

Closed forecast

When we click the 'Reset closed period range', all of the closed forecasts from the current year within the 'Closed Period Range' are reopened.

Reset closed period range
Reopened periods

In the above image, the Closed Period Range has been updated and closed periods in the current year are reopened.

iii) Update closed period

You can update the end date of the closed period range. First, reset the closed period using the steps outlined above. After clicking on the 'Reset closed period range', you can click on 'Update closed period range'.

Update closed period range

A pop-up opens where you can update the closed period. There is also an option to extend the forecast. You can update the closed period end date, and if required, you can extend the forecast. Click Preview and then Save.

Update closed period

The closed period is now updated as configured.

Updated closed period

iv) Re-configure open and closed periods

You can modify the open and closed period forecast values after they have been configured and created.

Configuring a forecast has been discussed here. You can modify them by clicking on the Re-configure option in the side panel.

Reconfigure

For example, in the image below, the open periods have been configured with a formula. Let's change it to data input, allowing users to enter forecast values. We have not set any default value here. Click on Update to save the changes.

Reconfigure periods

2. Re-forecasting

When using the data input option for open periods, you can update the forecast values for a specific period using the reforecast option.

For instance, let's say we have configured the forecast values to be blank. If we need to change the forecast for Q2 to the average sales of the previous year's Q2, you can reforecast for that period alone, without affecting the other forecasts.

Click on Plan > Time > Reforecast Measure.

Reforecast Measure

You can configure the forecast in the same manner as described in the section on configuring the forecast.

Reforecasting

Notice how the open forecast measures have been updated based on the re-forecast configuration.

Re-forecasted data

Last updated

Was this helpful?