Slider to Decrease a Number in a Field by Percentage

[RichardLinderman]

So I'm going to add a slider to my work. This slider is meant to represent percentage, so it will remain between 0 and 100. I have a KPI with a number, and what I want to happen is, when the slider is increased to a particular percentage, the percentage of the KPI number is subtracted. Can someone tell me what functions to type and where?

[LRuCelver · Accepted solution]

1. Create a variable and give it a meaningful name, e.g. "vKPIReductionPercentage". If you want it to have a default value, add "Let vKPIReductionPercentage = YourValue;" to the script. (Replace "YourValue" with your default value.)
2. Create a slider for the variable and set the lower and upper bounds to 0 and 100.
3. Multiply your KPI with "(1-$(vKPIReductionPercentage)/100)"

[RichardLinderman]

So, is "Let vKPIReductionPercentage = YourValue;" to be typed in the Definition box? If not, what should be?

[LRuCelver]

If you always want e.g. 0% as the default value, add "Let vKPIReductionPercentage = 0;" to the load script.

You can also create variables in the variable editor (bottom left corner when editing a sheet).