When working with Assumptions, a central workflow is to analyze the effect an individual Assumption has on your overall plan. You can do this in multiple ways by looking at

  • the Impact column in the Scenario Manager to see the sum of the data contained in each Line-Item
  • Node Impact columns in the Scenario Manager, to see the delta the Assumption triggers on a Node (e.g. the Profit Impact)
  • an Assumption Bridge that explains the delta between two Scenarios showing the effects of Assumptions
  • the effects of an Assumption in Charts and Tables

In the following, we will explain how to analyze the effects of Assumptions in Charts and Tables. 

You can activate the option "Show Assumption effects" for any Chart. This allows you to display the Assumption effects using Line and Bar Charts or Tables.

  • This will add an additional Filter for Assumptions to your Chart where you can select one or multiple Assumptions
  • The Chart will display the effect of your selected Assumption(s)
  • The subtitle of the Chart will show an indication that you are seeing the individual effect of an Assumption

Calculation Logic

The effect of an Assumption is calculated taking the delta between

  • the selected Scenario with the Assumption
  • the selected Scenario without the Assumption.

It does not matter if the Assumption is actually active in the Scenario as part of the selected Scenario. In any case, the calculated effect will be the same. Due to cross-effects between Assumptions, the value of an Assumption can differ depending on the selected Scenario.