Inforiver
FormulaPricingProductAll Products
Reporting & Writeback Matrix Docs
Reporting & Writeback Matrix Docs
  • Introduction to Inforiver
    • Why Inforiver
    • Get Started
      • Installing Inforiver for yourself
      • Installing from AppSource
      • Installing Inforiver for your organization (Org visual)
      • Inforiver Writeback Matrix pre-requisites
        • Whitelist Inforiver IPs
        • Admin consent for Inforiver's Entra ID
          • Basic consent
          • Full admin consent
      • Inforiver Customer Portal
        • Billing Admin
          • Update Profile
          • Update Subscriptions
        • License Admin
      • Licensing
        • License renewal
      • Registering Inforiver on Azure AD (Entra ID)
  • Working with Inforiver
    • 1. Build your first Inforiver report
    • 2. Displaying information
      • Report interface
      • Layout options
      • Templates
      • Basic formatting
        • Number formatting
        • Cell, header & value formatting
        • Totals & subtotals
        • Insert blank rows
      • Basic inline charts
    • 3. Basic interactions
      • Explore & filter data
        • Search & Filter
        • Explorer
        • Top N + others
      • Sort & reorder data
      • Show/hide values
      • Manage column widths
      • Manage hierarchies
      • Create visual hierarchies
      • Pin rows & columns
      • Blend measures
      • Dynamic measure headers
      • Context menus
        • Column gripper
        • Row gripper
      • Actions
        • Rails
        • Toolbar options
        • Keyboard shortcuts
        • Reset
    • 4. Adding business logic and formulae
      • Insert calculated rows
        • Template rows
      • Insert calculated columns
      • Insert manual input rows
      • Insert manual input columns
        • Number
        • Dropdown
          • Dropdown options from semantic models
          • Lookup visuals for dropdowns
        • Text, checkbox & date
        • Writeback Matrix features
      • Invert sign
      • Editing cells
      • Quick formula
      • Visual column inside visual measures
      • Manage inserted rows
      • Manage inserted measures & columns
      • Pivot data
      • Insert image URLs
    • 6. Working with charts
      • Sparkline charts
      • Stacked charts
      • Bullet charts and clustered bar charts
      • Waterfall charts
      • Bar and pin charts
      • Change/deviation charts
    • 5. Conditional formatting
      • One-click options
      • Create rule
        • Rules (If conditions)
        • Color scale & data bars
        • Classification
        • Ranking
      • Manage rules
    • 7. Planning, budgeting & forecasting
      • What-if analysis & simulations
      • Goal Seek
      • Scenarios (Writeback Matrix only)
      • Budgeting & allocations
      • Forecasting
        • Date rollover and extending forecasts
        • Editing forecasts and reforecasting
        • Autoclose forecasts
        • Distribute deficit
        • Row level forecast
        • User Access Control
        • Common Scenarios
          • Forecast using a Blank Template
          • Forecast using Existing Data
          • Adding Forecasts for Periods unavailable in the model
          • Creating daily and weekly forecasts
      • Set version
    • 8. Paginated reporting
      • Pagination
      • Header & footer
        • Text
        • Images
        • Charts
        • KPI cards
      • Report layouts (Report+)
      • Display and themes
    • 9. Commenting and collaboration
      • Notes
      • Comments
        • Data-level comments
        • Assign & track tasks
        • Track changes
        • Report-level comments
        • Comment settings
    • 10. Exporting reports
      • Export to PDF & Excel
        • Excel export - operational boundaries
      • Ad hoc emails
      • Snapshot (Writeback Matrix only)
        • Comparing snapshots
    • 11. Scheduling reports
      • Create new subscription
        • Select a report
        • Set subscription frequency
        • Select destination(s)
          • Email
          • OneDrive
          • Microsoft Teams
          • SharePoint
        • Review & save subscription
      • Manage your subscriptions
      • Administration
    • 12. Data writeback
      • Settings
        • General Settings
        • Data Settings
        • Destination Settings
        • Writeback security settings
        • Writeback time-out & batch size settings
        • Advanced Settings
      • Destinations
        • Azure SQL (Managed DB)
        • Azure SQL
        • Microsoft SQL Server
        • Synapse Dedicated SQL Pool
        • Azure Data Lake Storage
        • Databricks
        • Snowflake
          • Setting up Snowflake OAuth
        • Amazon Redshift
        • BigQuery
        • SingleStore
        • SAP HANA
        • Oracle
        • PostgreSQL
        • MySQL
        • OneDrive
        • SharePoint
        • Dataverse
        • Fabric Warehouse
        • Fabric lakehouse
        • Fabric SQL
        • URL as destination
      • Logs
      • Reading mode
    • 13. Context awareness
    • 14. Manage aggregation
      • Row aggregation
      • Column aggregation
    • 15. Managing Inforiver Writeback Matrix visuals
      • Inforiver deployments in Power BI pipeline setup
      • Duplicating Writeback Matrix Visuals - Best Practices
      • Recommended practices while working with Power BI desktop
    • 16. Approval workflows
    • 17. Collaborative adjustment workflows
    • 18. Variables
      • Variable types
        • Number
        • Select
        • Text
        • Date
        • Date range
        • Boolean
        • Button
      • Variable bookmarks
    • 19. Leveraging Power BI bookmarks
  • Admin Console
    • Manage Profile
    • User management
      • User Roles and Permissions
      • Create custom roles and policies
    • Settings
      • General
      • Generate builds - on prem
      • Forecast
      • Holidays
      • API token
      • Writeback
      • Managed DB
      • Assets
    • Onboarding actions
    • Writeback
  • Display settings
    • General settings
    • Hierarchy settings
    • Number settings
    • Miscellaneous settings
    • On-load scripting
  • Formula syntax
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
      • FILTERIF
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • AVERAGEIF
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • INDEXOF
      • LOG
      • ODD
      • MAX
      • MIN
      • NORMDIST
      • NORMSDIST
      • NORMINV
      • NORMSINV
      • PCT
      • POWER
      • RAND
      • RANDBETWEEN
      • ROUND
      • SORT
      • SQRT
      • SUM
      • PMT
    • Text formatting functions
      • CONCATENATE
      • HYPERLINK
      • LEFT
      • LOWER
      • MID
      • PROPER
      • REPLACE
      • REPT
      • RIGHT
      • TEXT
      • TRIM
      • UPPER
      • VALUE
    • Date functions
      • DATEADD
      • DATEDIFF
      • DAY
      • DATE
      • DATE.SET
      • DATE.FORMAT
      • SOWEEK
      • SOMONTH
      • SOQTR
      • SOYEAR
      • EOWEEK
      • EOMONTH
      • EOQTR
      • EOYEAR
      • NETWORKDAYS
      • ADDDAYS
      • ADDWEEKS
      • ADDMONTHS
      • ADDQTRS
      • ADDYEARS
      • FROMEXCELDATE
      • MONTH
      • NOW
      • PERIOD_RANGE
      • TODAY
      • TOEXCELDATE
      • YEAR
    • Time intelligence functions
      • AGGREGATE
      • FILTER
      • COLUMN_PERIOD
      • LASTNDAY
      • LASTNMONTH
      • LASTNQTR
      • LASTNYEAR
      • MONTHPERIOD
      • MOVINGAVERAGE
      • MOVINGSUM
      • MTD
      • NEXTNDAY
      • NEXTNMONTH
      • NEXTNQTR
      • NEXTNYEAR
      • QTD
      • QTRPERIOD
      • SHIFT
      • TOTALYTD
      • TOTALQTD
      • TOTALMTD
      • VALUEAT
      • YEARPERIOD
      • YTD
    • Other operators
    • Identifiers
      • CLOSEDPERIOD
      • COLUMN.DATE
      • COLUMN.PARENT
      • COLUMNS
      • CURRENT_PERIOD
      • DESCENDANTS
      • FORECAST.CLOSED_END
      • FORECAST.CLOSED_START
      • FORECAST.OPEN_END
      • FORECAST.OPEN_START
      • GROUP INDEX
      • HAS
      • HAS_ALL
      • HAS_SOME
      • LEAVES
      • LEVEL
      • LOGGEDIN_EMAIL
      • LOGGEDIN_NAME
      • MATCH
      • MAXDATE
      • MEMBERS
      • MINDATE
      • RELATIVE
      • RELATIVE_COLUMN
      • ROW.PARENT
      • ROW.LABEL
    • Scripting functions
      • DISPLAYTOAST
      • EXPORT
      • LAYOUT
      • SETCFRULE
      • SETFILTER
      • SETFILTERBYINDEX
      • SETVISIBILITY
      • SHOWBETWEENPERIOD
      • SHOWCLOSEDFORECAST
      • TOPN
      • DISPLAY SETTINGS
        • SETBLANKLABEL
        • SETSUPPRESSZEROS
        • SETRAGGEDHIERARCHY
        • SEPARATOR
        • SETCOMBINECOLUMNHEADER
        • SEMANTICFORMAT
        • SHOWNULLAS
        • SHOWZEROAS
        • SINGLECHILD
    • Miscellaneous functions
      • FETCH
      • LOOKUP
    • Measure/Column selection functions
      • GETCOLBETWEENPERIODS
      • GETMEASURE
  • Advanced topics
    • Audit log
    • Backup & restore report config
    • Enterprise themes
    • PowerPoint integration
    • Drill down and roll up in performance mode
  • Infobridge
    • 1. Create bridge
    • 2. Add source to bridge
    • 3. Bridge Interface
    • 4. Manage queries
      • Query transformations
        • Append
        • Join
        • Duplicate
    • 4. Manage sources
    • 5. Insert rows from bridge
    • 6. Insert measure from bridge
    • 7. Manage Integration of visuals
    • 8. Manage Bridges
    • 9. Data transformations
      • Pivot table
      • Group by
      • Add Column
      • Pivot column
      • Rename column
      • Find and Replace
      • Remove measure
      • Filter rows
      • Sort
      • Text functions
      • Unnest
      • Round
      • Extract Comments
      • Import and export
    • 10. Integrating forecasts
    • 11. Collaborative adjustments
  • Accessibility shortcut keys
  • Inforiver Reporting Matrix FAQs
  • Inforiver Writeback Matrix FAQs
  • Video tutorials
  • Resources
  • Release Notes
    • Inforiver Writeback Matrix May 2025 - v4.5 - Audit redesign
    • Inforiver Writeback Matrix May 2025 - v4.4.3
    • Inforiver Writeback Matrix April 2025 - v4.4.2
    • Inforiver Writeback Matrix April 2025 - v4.4.
    • Inforiver Writeback Matrix March 2025 - v4.3 - Time series formulae
    • Inforiver Writeback Matrix - March 2025 - v4.2
    • Inforiver Writeback Matrix March 2025 - v4.1
    • Inforiver Reporting Matrix March 2025 - V3.3.3 -New formatting and export options
    • Inforiver Writeback Matrix Feb 2025 - v4.0 - User permissions, High-performance mode, Input rules
    • Inforiver Writeback Matrix January 2025 - v3.9 - Fabric support, upgraded variables interface
    • Inforiver Writeback Matrix December 2024- v3.8 - Improved Scheduler Performance & Other Enhancements
    • Inforiver Writeback Matrix December 2024 - v3.7 - Merge rows, new rounding functions & More
    • Inforiver Writeback Matrix November 2024 - v3.6.2 - Import from Google Sheets & More
    • Inforiver Writeback Matrix October 2024 - v3.6 - Approval Workflows & Other Enhancements
    • Inforiver Writeback Matrix October 2024 - v3.5 - Lookup visuals & more
    • Inforiver Reporting Matrix Nov 2024 - v3.3 - Variables
Powered by GitBook
On this page
  • 1. Generating a forecast
  • 2. Configuring the forecast
  • 3. Analysing the forecast
  • 3. Forecast customizations

Was this helpful?

  1. Working with Inforiver
  2. 7. Planning, budgeting & forecasting

Forecasting

PreviousBudgeting & allocationsNextDate rollover and extending forecasts

Last updated 6 months ago

Was this helpful?

With Inforiver, you can easily generate a rolling forecast and use methods like period range, average of period range, or apply formulas to initialize the forecast. Leverage the integrated time intelligence and time extension features to create half-yearly forecasts or fiscal period forecasts. In this section, discover how to configure forecasts, close the forecast once actuals are available, update forecasts, distribute deficits, and extend forecasts.

1. Generating a forecast

To create a forecast, click the Insert Forecast button in the Insert ribbon. The forecast dialog box allows you to configure forecasts for open(future) and closed(past) periods.

1. Measure name: By default, the forecast measure is named ‘Forecast’. This can be updated to a relevant column name.

2. Forecast period: The time frame for which the forecast is being generated. Inforiver's time intelligence sets the start date to the current month - you can update the range based on your requirements.

3. Closed Period: The new forecast measure will be created for past or closed periods as well. If you have actuals for 2024 and are generating a forecast for 2025, 2024 will be considered as the closed period. Inforiver provides 2 options to populate closed forecasts:

  • Measure: The Linked Measure dropdown option allows you to select native measures, data input measures, formula measures, or other forecasts as the source for closed periods. For instance, if you select the Revenue - formula measure, closed periods will have the values from the formula measure.

There will be differences in the totals and sub-totals when formula measures are used to populate forecasts. This is because the default aggregation method for formula measures is 'Formula' and 'Sum' for forecasts.

  • Formula: You can write custom formulas and leverage Inforiver's extensive selection of built-in formulas to populate closed forecasts.

4. Open Period: Inforiver offers a range of options to configure forecasts. You can source forecasts from native measures/visual measures, use formulae, or enter values with the data input option.

  • Measure

If you already have projections in your data source, you can populate the forecasts for open periods from a native measure with the Measure option.

You can hide the native measure after creating the forecast to avoid displaying the data twice.

  • Formula

You can apply formulas to native measures/visual measures to generate forecasts. In this example, we've created a revenue forecast by multiplying 25% of the projected sales(native measure) with the projected quantity(data input measure).

  • Data input

You can specify a default value if you choose to manually input forecast values. The default value can be static, a measure, formula or left blank.

a) Static value

The specified static value will be used as a default value when the configured forecast values are null. In the example, the forecast has been created from the ProjectedRevenue native measure which is blank for the Juices category. The static value of 5 million is used in the forecast measure as the default value.

b) Measure

You can use a visual or native measure as the default forecast value when forecasts are blank. In the example, the forecast is based on the ProjectedRevenue native measure which is null for the Juices category. The EnhancedSales data input measure has been used as the default forecast instead of displaying null values.

c) Formula

You can also use a formula as a default value. In this case, we've used 25% of the EnhancedSales data input measure as the default forecast value.

2. Configuring the forecast

Inforiver allows you to create rolling forecasts and choose different methods to populate the forecast values.

These options are applicable only if you choose Data Input for open periods.

1. Target period: You can split the forecast period into shorter time frames or configure the forecast for the whole period. In this case, we have split the forecast period into 3 parts: January to March, April to June, and July to December.

You can also configure for the entire period in one shot as shown below.

2. Select source: You can choose any of the options listed below to populate the forecast-

  • Blank: Enter values manually

  • Use a measure

  • Upload forecast from a file

If you choose to upload forecast values from a file, Inforiver will generate a template file that you can download. You can fill the forecast values in the template file and upload them to the visual.

3. Apply operation: There are 3 different methods that you can use to generate a forecast:

  • Period range: The values from a specific period range will be used to initialize the forecast. In this case, we have used the sales from Q4 2023 (Copy period range) to populate the forecast for Q1 2024 (Target period). The duration of the period range should match the duration of the target period. E.g., if the target period is 6 months, then you must select a period range spanning 6 months.

  • Single period: The values for a specific month will be used to initialize the forecast. In this case, we have used the revenue from December 2022 to populate the forecast for Apr to Jun 2024.

  • Average of period range: The average of a custom time period will be used to initialize the forecast. In this case, we have used the average revenue from Jan 2022 to Dec 2023 to initialize the forecast.

4. Copy period range: The time frame for which to copy data from the source measure.

3. Analysing the forecast

Let's look at the forecast generated with the configurations in the earlier sections.

  • Closed period forecasts

  • Forecast using period range

In the example, we've used the Sales measure from Oct to Dec 2023, to populate for forecast from Jan to Mar 2024.

  • Forecast using single period

We've used the revenue from December 2022 to create the forecast from April to June 2024.

  • Forecast using average of period range

We've used the average revenue from Jan 2022 to Dec 2023 to create the forecast from July to December 2024.

3. Forecast customizations

Inforiver offers customizations that can be applied once the forecast is created.

3.1. Action for closed periods

You have the flexibility to retain the forecasted values or use the actuals after closing a forecast. Navigate to Manage Forecast > Click the edit button against the forecast measure > Action for closed periods section.

a) Overwrite forecasts (default)

The forecasted values are overwritten when the period is closed and the actuals become available. The forecast values are highlighted in blue indicating that they are linked to an actuals value - any updates made to the actuals will be reflected in the forecast. To view the underlying actuals measure, navigate to edit forecast > Linked Actuals Measure.

We've created a forecast from September to December. When the actuals become available for September and the period is closed, the forecasted values are replaced by the actuals.

b) Retain forecasts

The forecasted values are retained even after the actuals are available. This setting enables you to compare the actuals against the predicted values.

3.2. Aggregate forecast grand total

If the column grand total is enabled, you can choose whether the grand total for the forecast measure should be derived from open periods, closed periods, or both. To customize the grand total for forecasts, click on the forecast column gripper and select the desired option from the Aggregate total section.

a) All Periods: The grand total forecast will be the aggregate of the forecasts for open and closed periods.

b) Open Periods: The grand total forecast will be the aggregate of the forecasts for open periods only. The open periods in the example are 2025 Q1 and Q2, hence these will be used to calculate the grand total forecast.

The subtotal forecasts for 2023 and 2024 go blank when the Open Period option is selected. This is because 2023 and 2024 only have closed periods.

c) Closed Periods: The grand total forecast will be the aggregate of the forecasts for closed periods only. In this example, the closed forecasts for 2023 and 2024 are used to calculate the grand total forecast. The subtotal forecast for 2025 is blank as 2025 only has open forecasts. The fields highlighted in red are the closed forecasts, and the field highlighted in green is the forecast grand total.

3.3. Forecast subtotals

Similar to grand total forecasts, you can choose the aggregation method for forecast subtotals. The same 'All', 'Open Periods', and 'Closed Periods' options apply to forecast subtotals.

a) All Periods: The subtotals for the forecast measure will be the aggregate of the forecasts for open and closed periods. In the example, the fields highlighted in red are the forecast subtotals, the fields in blue are the closed periods and the fields in green are the open periods.

b) Open Periods: The forecast subtotals will be the aggregate of the forecasts for open periods only. The forecast subtotal for 2024 is blank as 2024 does not have any open forecasts.

c) Closed Periods: The forecast subtotals will be the aggregate of the forecasts for closed periods only. The fields highlighted in red are the forecast subtotals and the fields highlighted in green are the closed forecasts.

3.4. Show or hide closed periods

You can choose whether to display the forecasts for closed periods. To mask the forecast for closed periods, click on any forecast that is generated for closed periods, click on the Show/Hide icon, and choose Hide closed periods.

The forecast for the closed period is hidden as shown in the image below.

To un-hide the forecasts for closed periods, click on any measure belonging to the closed period, click on the Show/Hide icon, and select Show closed periods.

The forecast measure generated for previous or closed periods will be greyed out and cannot be edited. Refer to section 1, to learn more about configuring closed periods.

generating a forecast
Forecast configuration for open and closed forecasts
Measure option for closed forecasts
Closed forecast from formula measure
Native measures to populate closed forecasts
Formula based closed forecast
Using a source measure for forecasts
Open forecast created from a measure
Populating forecasts from formulas
Default data input options
Static default value for forecasts
Default static value used in forecasts
Set a measure as default forecast value
Measure used as a default value
Formula as default forecast
Default forecast generated from a formula
Rolling forecast
Configuration for entire period
Forecast source options
Downloading and entering values in the template file
Forecast values uploaded from an excel file
Period range
Single period
Average of period range
Period range
Single month
Custom time frame
Forecasts for closed periods
Period range
Forecast using single period
Average of period range
Forecast created from Sep - Dec
September forecast overwritten with actuals
Forecast generated from Sep - Dec
Sep forecast retained after period close
Aggregate total for forecasts
All periods aggregated forecast
Grand total aggregation for open periods
Closed forecast periods for 2024
Closed period aggregation for grand total forecast
Open and closed forecasts used in calculating forecast sub totals
Show/Hide forecasts
Hide forecast for closed period