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?

1 Like

Hi @nirmay.panchal. That’s a great question. You can do the same as follows:

- Create a variable for the
`primary CAC`

and 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