Percentage Growth

[sqlpuzzle]

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

[ahaahaaha]

Hi,

May be like as at attached file.

Regards,

Andrey

[Frank_Hartmann]

for %change try with this expression:

=(Num(Population,'###,##0') - above(num(Population,'###,##0')))/(Num(Population,'###,##0'))

[sqlpuzzle]

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

[sqlpuzzle]

Hi Frank,

I tried the expression in the TX01 object and it did not work. Is it a different formula for the TextBox?

Thanks

[Frank_Hartmann]

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?

[sunny_talwar · Accepted solution]

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

[sqlpuzzle]

Growth% from the Start to End based on the Slider.

((Population at End Slider) - (Population at Start Slider))/ (Population at Start Slider)