Row level forecast
Create row-level forecasts to predict outcomes at a detailed level, such as based on the region or product line. After creating a regular forecast, you can create row-level forecasts by selecting a row and choosing the Forecast Row option from the Insert Row menu.
1. Generating a forecast
The options shown in the screenshot need to be configured to generate a row forecast.
1.1. Row name: The row category label that will hold forecasted values.
1.2. Insert as: Choose to insert a single forecast row or replicate the forecast row across all levels of the hierarchy with the Templated option.
Select the Templated option when the row categories repeat across all levels of the hierarchy.
1.4. Closed period: The forecast row for earlier or closed periods can be populated by referencing the values from another row or by entering a formula.
1.5. Open period: The forecasts for future or open periods can be populated in 3 ways
Linked row: Refer to the values from another row.
Formula: Enter a formula to populate open forecasts.
Data input: Manually enter forecast values. When you choose the data input option, you can specify default values for the forecast. Opt for a static value, reference another row, or specify a formula.
2.1. Target periods: The forecast time frame is configured when you create a forecast measure. You can configure the entire row forecast with a single time range or split the forecast period into multiple time frames. Use the Add Range link to create additional forecast ranges.
When you split the forecast time range, you must create time ranges spanning the entire forecasting period. For example, if your forecasting period is Jan 2025 - Dec 2025, you must cover this entire time period when you split it. Inforiver will display a red error icon and will not allow you to create the forecast until all the time ranges are configured.
2.2. Set source: You can opt for a blank forecast to manually enter values or refer to another row.
2.3. Source row: When you choose the By Row option in the previous step, you need to select the row whose values will populate the forecast.
2.4. Operation: You can create forecasts using the following options:
Period range: The forecast values will be copied from the range specified. In this case, we are sourcing the forecast for Jan 2025 to Mar 2025 from Oct 2024 to Dec 2024.
Single period: The values from the selected period are used to populate the forecast.
Average of period range: Use the average of the selected period range to populate the forecast.
Last updated
Was this helpful?