Help & Support ↗ Lucanet Learning Space ↗
Getting Started
Global Functions
Administration
Extended Planning & Analysis (xP&A)
xP&A Video Tutorials
User Roles in Lucanet xP&A
Lucanet xP&A User Interface
All Steps at a Glance
Basic Concepts and Elements
Creating a Model
Integrating Data
Modeling Your Data
Viewing and Visualizing Data
Using Dashboards
Using Scenarios
Using Charts
Using Tables
Using Views
Comparing Versions or Scenarios in Charts and Tables
Using Time Aggregation and Relative Comparisons
Working with Models
Using Comments and Descriptions
Comparison: xP&A vs. Excel Performance
Consolidation & Financial Planning
ESG Reporting
Disclosure Management
XBRL Tagger
Lease Accounting
Banking & Cash Management
Data Collection
Tax Compliance & Reporting
Glossary

Using Scenarios

Overview

A scenario is a live variant of your model in which some variables (or cells of a variable) have different values or formulas. The structure of the model — the variables, groups, and sections — does not change across scenarios.

This is useful when comparing different discrete options. For example, you might be trying to decide whether to hire 5 people or 10 people this year.

Creating a Scenario

Do one of the following to create a new scenario:

  • Right-click on a variable and click New Scenario.
  • Click Scenarios in the toolbar, and then click +.
Shows the + button in the Scenarios menu that is used to create a new scenario
Creating a new scenario

Rules when changing formulas and/or values in scenarios

  • If you change (override) the formula and/or value of a cell, that cell will no longer be linked to the default scenario (but the rest of the variable will).
  • If you change (override) the entire variable's formula, then the entire variable will no longer be linked to the default scenario.
  • Any variables and cells you do not change or override, will still be linked to the default scenario (so any formula and/or value updates in the base model will flow through).
  • If you want to remove the override in the scenario, hit Reset row or Reset override. This will revert the formula to match the default scenario, and reinstate the link (so that any future updates to the base model will flow through).
  • Variables and/or cells that have been changed in a scenario will have a pink background.

If you have a set of linked models - the scenario will automatically apply across all models. If you subsequently create a new linked model they will be automatically pulled across.

Editing a Scenario

Selecting a scenario under Scenarios in the toolbar, will take you into Scenario mode. In this mode, you will be able to change the value of any variable and/or cell, and this change will only be applied in the active scenario.

Additional Functions for Scenarios

You also have the following functions available via the three-dots menu of a scenario:

Shows additional functions that can be opened using the three-dot menu behind 'My scenario'
Additional functions for scenarios

Overriding the default scenario

If other scenarios exist after overriding the default model with another, all unchanged values for variables in the other scenarios will all revert to the values of the new, default model.

In other words, if you have a base model and two additional scenarios: Scenario A and Scenario B, and the base model is overridden by Scenario A to be the default model, then all of the variables in Scenario B that were unchanged from the original, default scenario, those variables will now take on the values of the new, default scenario.

Comparing Scenarios in Charts and Tables

You can visualize multiple scenarios together in charts and tables, to easily compare them. For a comprehensive overview of this functionality, youcan consult the documentation of the former product Causal: Comparing scenarios in charts/table

Please keep in mind that some functionalities may differ from the Lucanet xP&A solution.

Last updated on Aug 16, 2023

Table of Contents
Using ScenariosOverviewCreating a ScenarioEditing a ScenarioAdditional Functions for ScenariosComparing Scenarios in Charts and Tables
Related Articles

Company

Legal Notice

© Copyright 2026 - Lucanet AG