Is there a way to compare easily Scenario between them ?
E.g: I want to compare Budget 1 vs Budget 2 with variation (value and %). But I also want to compare Budget 2 vs Budget 3 the same way and I don’t wan’t to create another view with another calculated item, because I have numerous scenario to compare.
The idea is to have a var (value and %) between 2 scenario by selecting them. Is it possible ?
Hello, anyone to answer ?
You can use Add Calculated item for Variance% and Variance Absolute
Use Custome Calculation to calculate
I just didn't want to use this because I have to do it for each scenario I want to compare.
I was looking for another solution
May be you already found a solution to your problem, but here is my proposition :
Use named variables for your scenarios (see here)
This way you can have Budget 2 as “Current Budget” and Budget 1 as “Previous Budget” and create your calculated item using this variables.
Next run, you only switch Budget 2 as “Previous Budget” and ‘Budget 3” becomes your new “Current Budget” and your boards and views will remains ok.
Hope this helps !
Hi, thanks for your answer but that’s not what I want to do !
I guess there is no solution at the moment for this
My name is Jacob from the Pigment support team.
The only way to do this would have been through versions:
Understanding that this is for versions, this would not work in scenarios, however I do see the value of how adding a scenario to a metric or be able to be referenced in a formula would be beneficial in this scenario.
I encourage you to create a feature request on our ideas page here and share it with your colleagues to upvote it.
Our Community Ideas Portal is our primary way of tracking enhancement requests. This allows other users to upvote Ideas and share their use cases which helps our Product Team to prioritize requests.