How do I assign relative values in scenarios as opposed to absolute values. For example If my primary scenario has a variable for the estimated CAC with the value of $100 so how do I make scenarios where let’s say the CAC is 10% higher or 5% lower rather than having absolute values such that if I change the primary scenario, the other scenarios adjust with the change?
Hi @nirmay.panchal. That’s a great question. You can do the same as follows:
- Create a variable for the
primary CACand assign it with a value that would like to have for the base scenario. Note that this variable should strictly be consistent across all scenarios.
- Now you can create a variable for the variance in scenarios (Lets call it
CAC scenario variance). This variable will have the value of 0% in your base scenario and take different values in the other scenarios. According to the example mentioned, it will take the value of 10% and -5%
- Finally you need to create a final variable (Let’s call it
Final CAC). This will take on a formula similar to
primary CAC *(1+CAC scenario variance). This variable will now have the desired values in all scenarios and can be used in your calculations