What if analysis / scenario

[#1]

Hi Guys,

not sure if this possible.

I would like to setup a slider for my markup %, so when I change my slider on a particular product in the table it will show the impact on my net profit.

Product	Sales	Markup %	Net Profit %	Slider
A	$500	25%	6%	1%        100%           -------------------
B	$350	10%	2%	1%        100%           -------------------
C	$425	12%	5%	1%        100%           -------------------
D	$150	18%	12%	1%        100%           -------------------

Thanks

[Gysbert_Wassenaar]

No, inline sliders aren't possible. You could set up four sliders using four variables and use an if-statement in your chart expression to pick the variable that goes with the product.

Or perhaps you could define Markup % as an input field in the script. That allows you to change the values in the Markup % field in the chart directly.

[#3]

Hi Gysbert,

Thanks for your response, could you please provide me with some examples of how the if statements would look.

Thanks