ValQ - Plan
FormulaProductChangelogStart Trial
  • Introduction to ValQ
    • Get ValQ
    • The ValQ Workflow
  • Model
    • Get Data
    • Create Model
      • Dynamic Model
      • Custom Model
      • Import a Model
    • Model Editor
      • Node Operations
      • Editor Features
    • Node Settings
    • Templates
      • Apply Template
      • Manage Template Nodes
      • Import Template
      • Export Template
    • Formula Functions
      • Logical Functions
        • IF
        • SWITCH
        • AND
        • OR
        • NOT
        • XOR
        • IFNAN
      • Math Functions
        • SUM
        • SUBTRACT
        • PRODUCT
        • DIVISION
        • AVERAGE
        • AVERAGEEXZERO
        • AVERAGEEXNEG
        • AVERAGEEXZERONEG
        • COUNT
        • ABS
        • MIN
        • MAX
        • POWER
        • SQRT
        • EXP
        • LOG
        • ROUND
        • FLOOR
        • CEILING
      • Finance Functions
        • IRR
        • NPV
        • PMT
        • IPMT
        • FV
        • PV
        • CUMIPMT
        • CUMPRINC
        • RATE
      • Range Functions
        • RANGE
        • LastNPeriods
        • Get
        • ForEach
        • findByTitle
        • GETCURRENTRANGE
        • GETROWVALUE
        • THIS_SOURCE_KEY
        • PERIOD_LOOKUP
        • PRIOR_SERIES_PERIOD_LOOKUP
      • Static Identifiers
        • THIS/ME
        • CURRENT_SERIES*
        • CURRENT_SERIES_ID*
        • CURRENT_PERIOD_INDEX
        • CURRENT_NODE_VALUES
        • DS.SERIES
      • Node Properties
        • Node Properties Explanation
    • Global Settings
  • Plan
    • Create New Plan
    • Time Series Forecasting
    • Allocation Features
      • Goal Seek
      • Distribute
      • Copy to Periods
    • Driver Based Planning
      • Enabling Driver Based Plan
      • Configuring Driver Inputs
      • Bulk Configuration of Drivers
    • Plan Interface
  • Simulate
    • Create a Scenario
    • Perform Simulations
    • Manage Scenarios
    • Simulation Interface
    • Add Notes
    • Compare Scenarios
    • Scenario Analysis by Node
    • Create Initiatives in a Scenario
      • Steps to create initiatives
    • Create your Presentation
    • Understanding the Node Components
  • Report
    • Variance Analysis Report
  • ValQ Premium FAQs
  • Glossary
  • Resources
  • Release Notes
Powered by GitBook
On this page
  • Manage Scenarios
  • Download Scenario Comparison
  1. Simulate

Compare Scenarios

PreviousAdd NotesNextScenario Analysis by Node

Last updated 1 year ago

Multiple scenarios can be created, simulated and compared to perform scenario analysis. Click on Compare on the navigation panel to open the Scenario Comparison window.

In Scenario Comparison pop-up, all the scenarios are listed under the baseline using which it was created, and all the series including plan series are also available for comparison. Select the required scenarios and data series that you want to compare by checking them and then click Compare.

This opens the Compare Scenarios window where the top node value, KPIs, key inputs and simulation summary for all chosen scenarios and data series can be compared alongside each other.

The current or the active scenario is highlighted with a blue outline in the Compare Scenarios window.

Manage Scenarios

Click on Manage Scenarios to add or remove any existing scenarios and series.

Alternatively, you can click on the + icon to add an existing scenario or data series for comparison. Click on the bin icon to remove them from the comparison window.

Other features available in this window are highlighted in the below image.

Add KPI: Add any node as a KPI by clicking on +Add to compare.

Download Scenario Comparison

To export the scenario comparison data to Excel, click on Download as Excel option.

This not only exports the KPIs, Key Inputs and simulation summary as seen in the window but also all the node values in the model for the respective scenarios and series under comparison.

Edit Simulation: This icon opens the Edit Simulation grid where you can manually edit the values for simulation at the period level for the desired nodes. This is already discussed .

Simulation Impact: Clicking this icon opens a waterfall chart showing the breakdown of the Simulation Impact on the top node for that specific scenario.

Go to Scenario: Navigate to the respective Scenario's tree model on the simulation canvas by clicking this icon .

Remove: Finally, bin icon is used to remove the scenario from comparison.

Add Note: Click this icon to add a note and this icon to view already added notes.

here
Click Compare for scenario comparison
Select scenarios & series to compare
Scenario Comparison
Manage Scenarios
Manage Comparison Features
Waterfall Chart for Total Net Profit - Scenario 2
Download as Excel