Skip to main content

Hello everybody,

Does anybody know if it is possible to use scenario's as an incremental effect to the default scenario? For my use case: I have a default scenario where my users are inputting their baseline forecast for the coming months/ years. I would like for them to be able to also model the associated risks & opportunities as incremental effects to that baseline forecast. So, basically: default scenario + opportunities = best case scenario. And; default scenario + risks = worst case scenario. And: default scenario + opportunities + risks = realistic scenario. 

I have tried copying scenario inputs from scenario A to scenario B, but that only overwrites the initial data in scenario B instead of data from A being appended to B. 

Manually copying and pasting all inputs from A to B and then adding additional input in B is too much of a hassle. Let alone that you'd have to keep in mind to update 3 scenario's if you change something in the baseline. 

It would be great if there's an elegant solution to this problem.

Thanks!

Bas

My understanding is that scenarios in pigment work as completely separate watertight layers that cannot be summed the way you intent (e.g. you cannot  sum scenarios together in any way)

If you d want to go the additive layers way, you need to model it wity a specific dimension.

As pigment has a default "sum all" on agregations, especially if you remove a dimension, it might be not so difficult to model / add layers dim in already applications.


Hi ​@Bas ,

​@FPA You’re right—Pigment scenarios don’t support formulas between each other. However, maybe I’m missing something but you can achieve your goal by using a custom dimension (like "Forecast Type") instead of scenarios. 

  • Baseline (Input): Your core forecast.
  • Opportunities (Input): Positive adjustments.
  • Risks (Input): Negative adjustments.
  • Best Case: Baseline + Opportunities (using Calculated Item Sum).
  • Worst Case: Baseline + Risks (using Calculated Item Sum).
  • Realistic Case: Baseline + Opportunities + Risks (using Calculated Item Cumulate).


Let me know,
Best,

Ask your question here!

Terms & ConditionsCookie settings