Variable Input - %

[thomas_2583]

Hi, 

I have a KPI which shows me Total_Income ($50,000). 

I have added in a Variable Input where by I want to use this to amend the Total_Income by changing the %.

So, if I chose 2% on the Variable Input Slider, my Total_Income KPI would then show $49,000

Any idea what I need to do to the Variable Input slider to make this work please?

[martinpohl]

Hi Thomas,

so change your expression to sum(Total_Income) to sum(Total_Income)*((1-variable)/100)

Regards

[QFabian]

hi, try to make your slider with negative and positive values, in order to get the correct value.

Check that you can put decimals values shown as percentage, so you have to heck if you need the '/100' part

I changed a little the expression of @martinpohl :

 = sum(Total_Income)*((1+$(variable))/100)