Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to find the percentage change.
I have a slider that selects the year range. And a Line chart. I need to display the percentage change of the measure as a KPI.
What is the formula to do that?
Thanks
What would be the growth number you would want to see? from 1976 to 1989? May be this
=Num(Only({<Year = {$(=MaxString(Year))}>}Population)/Only({<Year = {$(=MinString(Year))}>}Population) - 1, '##.00%')
Note: I had to use MaxString and MinString because your year field is a text, rather than a number. Convert it to number and you should be able to use Max and Min instead of MaxString and MinString
Hi,
May be like as at attached file.
Regards,
Andrey
for %change try with this expression:
=(Num(Population,'###,##0') - above(num(Population,'###,##0')))/(Num(Population,'###,##0'))
Andrey,
The expression you gave is very handy.
I put that expression into the Textbox object with ID 'TX01'. It showed just a -, I guess some placeholder for null values.
I am looking for getting it as a KPI in the text box. Not as another chart.
Thanks
Hi Frank,
I tried the expression in the TX01 object and it did not work. Is it a different formula for the TextBox?
Thanks
in a textbox you are showing only one singele value!
if you are setting up the range by slider how should the % changed be applied!
means, which % change do you want to show? from beginning of the range to the end of the range?
can u give more details?
What would be the growth number you would want to see? from 1976 to 1989? May be this
=Num(Only({<Year = {$(=MaxString(Year))}>}Population)/Only({<Year = {$(=MinString(Year))}>}Population) - 1, '##.00%')
Note: I had to use MaxString and MinString because your year field is a text, rather than a number. Convert it to number and you should be able to use Max and Min instead of MaxString and MinString
Growth% from the Start to End based on the Slider.
((Population at End Slider) - (Population at Start Slider))/ (Population at Start Slider)