> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends/edit-forecast-settings.md).
# Edit forecast settings
Keep forecasts aligned with reporting cycles by editing the forecast period, managing closed periods, configuring aggregation, and defining how actuals update forecast results.
### Editing forecasts
Go to **Planning**> **Insert Column** > **Manage Measures** and select the edit icon for the forecast measure.
{% hint style="info" %}
Forecasts can be edited by selecting Edit Measure from the column gripper.
{% endhint %}
* To extend or shorten the open period, select the end period from **Forecast Period**.
The open forecast is shortened till Q3, and the Q4 forecast is removed.
* Use **Closed Period Range** to reopen forecasts. Select the period up to which closed forecasts should be reopened.
{% hint style="info" %}
Select **Reset closed period range** to reopen all closed forecast periods.
{% endhint %}
The Q2 forecast is reopened.
* To change the values used to populate open and closed forecasts, select **Re-configure** and edit the default value configuration.
### Set forecast aggregation for column totals
When the grand total or subtotal columns are enabled, configure how the forecast measure total is calculated.
* Set **Aggregate total** to **All Periods** to calculate the total as the sum of open and closed forecast periods.
* Set **Aggregate total** to **Closed Periods** to calculate the total as the sum of closed forecast periods.
* In the same way, set **Aggregate total** to **Open Periods** to include only open forecasts in the total.
### Control forecast updates from actuals
Define how the forecast responds as actuals are loaded. Choose to replace forecast values with actuals or keep forecast values unchanged.
To replace forecasted values with actuals as they become available, the **Closed Period** configuration must be set to **Measure**.
* Choose **Overwrite forecasts** to replace forecasted values with actuals when the forecast for that period is closed.
* To preserve forecasted values, choose **Retain forecasts**.
* Select **Retain blank values** to leave empty forecast cells unchanged when the forecast is closed.
When the forecast is closed, blank values are replaced with actuals unless explicitly retained.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends/edit-forecast-settings.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.