# Insert forecast rows

Create row-level forecasts to predict outcomes at a detailed level, such as by region or product line. After creating a forecast measure, you can generate forecasts at the row level by inserting a forecast row.

{% hint style="warning" %}

#### Note

The **Forecast** row option is available only when the report contains forecast measures. For more information, see [forecast measures](/planning-sheets/how-tos/forecast-data-to-predict-future-trends.md).
{% endhint %}

In this article, you learn how to create and configure forecast rows.

### Insert a forecast row

1. Select the row where you want to create the forecast.
2. Go to **Planning** > **Insert Row** > **Forecast**, or use the **row gripper** > **Insert** > **Forecast Row.**

<div align="right"><figure><img src="/files/L0myiokCfuz5mqJkMB0U" alt="" width="375"><figcaption></figcaption></figure> <figure><img src="/files/QjBvLI2TKwe6gfjbtFQM" alt="" width="336"><figcaption></figcaption></figure></div>

3. In the Forecast configuration window, enter a row name and [configure](#configure-forecast-row-properties) the required options.
4. Select **Save** to generate the forecast row.

### Configure forecast row properties

You can configure the following options while creating a forecast row:

* **Row name**: Specifies the label for the forecast row.
* **Insert As**:
  * **Single Row** - Inserts a single forecast row.
  * **Templated Row** - Replicates the forecast row across all hierarchy levels.

<figure><img src="/files/FPS7uWWjbtpHhCuOXOLx" alt="" width="563"><figcaption></figcaption></figure>

* **Closed period**: Populate past or closed periods by:
  * Referencing another row: Select **Linked Row** in **Closed Period** and choose the row you want to refer.
  * Defining a formula: Select **Formula** in **Closed Period** and define the formula.

<div align="left"><figure><img src="/files/8tNOxsxjuUEph0rJxILU" alt="" width="563"><figcaption></figcaption></figure> <figure><img src="/files/QuGRSWfgZ4YcoVIRLzK1" alt="" width="563"><figcaption></figcaption></figure></div>

* **Open period**: Populate future periods using one of the following:
  * **Linked row:** Reference values from another row.
  * **Formula:** Define a formula for forecast values.
  * **Data input:** Manually enter forecast values with optional default values using a **static** value, another **row**, or a **formula.**

<div align="left"><figure><img src="/files/UTKKMXLUVaH7gNsFrn8K" alt="" width="563"><figcaption></figcaption></figure> <figure><img src="/files/sXazbO8UwhzsdqYrDPEd" alt="" width="563"><figcaption></figcaption></figure></div>

{% hint style="info" %}
Select the **Templated** option when the row categories repeat across all levels of the hierarchy.
{% endhint %}

### Configure forecast range

The forecast time frame is configured when you[ create a forecast measure](/planning-sheets/how-tos/forecast-data-to-predict-future-trends.md). After configuring forecast row properties, select **Next** to define the forecast time range in **Target Periods**.

{% hint style="info" %}
The **Next** option to configure the period range is available only when **Data input** is selected for the **Open period**.
{% endhint %}

You can configure the forecast range using one of the following options:

* Apply a single configuration for the entire period.

<figure><img src="/files/gMD6vXkueKnCygPqSaZf" alt="" width="563"><figcaption></figcaption></figure>

* Split the forecast into multiple time ranges using **Add Range.**

<figure><img src="/files/W8zTtYQOG76ro5ZRQJY8" alt="" width="563"><figcaption></figcaption></figure>

When splitting the forecast period, ensure that all time ranges together cover the entire forecasting duration. Otherwise, the forecast cannot be created.

### Configure forecast source

* **Set source**: Choose how to populate forecast values:
  * Use a blank forecast (manual input)
  * Reference another row

<figure><img src="/files/D0LRg7C4sw5XmzGdL31e" alt="" width="563"><figcaption></figcaption></figure>

* **Source row**: Select the row whose values will be used when sourcing by row.

<figure><img src="/files/Xde7Av11bk5Fnrr9HPaI" alt="" width="563"><figcaption></figcaption></figure>

* **Operation**: Define how forecast values are calculated:
  * **Period range** - Copy values from a selected time range.
  * **Single period** - Use values from a specific period.
  * **Average of period range** - Use the average of selected periods.

<figure><img src="/files/fnbyuXmmFOcTRKsmfNXp" alt="" width="563"><figcaption></figcaption></figure>

### Edit and update a forecast row

You can edit an existing forecast row by selecting the edit icon on the row. The side panel opens as shown below, where you can update the following properties:

<figure><img src="/files/YJ8raLzCMlnIf3sf3f5o" alt="" width="375"><figcaption></figcaption></figure>

* Edit the **Title** as needed.
* Re-configure **Period Settings** to update forecast values for closed and open periods.
* Configure **Scaling Factor**, **Bind for Cross filter/RLS**, **Include in total**, **Allow Input** and **Description.**&#x20;

For more information, see [data input row properties](/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-manual-input-rows.md#data-input-row-properties). After making the required changes, select **Update**.

<figure><img src="/files/j8JTEMzGhJi0HyGCFMBc" alt="" width="375"><figcaption></figcaption></figure>


---

# Agent Instructions: 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:

```
GET https://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-forecast-rows.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.