"what if Analysis"

[Motorsport28]

Hi Guys

Im working on a variable which i would like to increase my total revenue in percentage...I have been doing some searching and found a way to create a varable but it only increases my total revenue by values like 10, 20, 30 etc.. how do i change this to say 10%,20%

Thanks

[JordyWegman · Accepted solution]

Hi,

You can create a variable with a value of 0.2 (because 0.2 = 20%).

VariablePercentage = 0.2 (in variable overview)

Then you can create a button, or maybe a input box to change this value.

At last, use this variable in combination with your total revenue:

Sum([Total Revenue]) & $(VariablePercentage)

 Jordy

Climber

[Motorsport28]

Thanks so much! 

Really appreciate it,

Worked!

[JordyWegman]

Great, good to hear! Good luck with it and please mark the post as solved!

[Motorsport28]

I have tried but as soon as i click accept as solution it logs me out??