Increase or decrease in %

[francisvandergr]

Hi,

I have a dashboard with an example:

column1    Year

column2   Turnover

column3   % increase or decrease to last year

So i want the following table :

Year	TO	% Increase
	7320
2005	1000
2006	1010	1
2007	2020	100
2008	1010	-100
2009	1111	10
2010	1111	0
2011	3333	200

Can someone help me

[mphekin12]

try this expression for the % Increase/Decrease:

=if(Turnover >= above(Turnover)

,((Turnover/above(Turnover))-1) * 100

, ((Turnover/above(Turnover))) * -100

)

[swuehl · Accepted solution]

I think (using your expression label TO from your sample, or replace with your expression to calculate the turnover):

=(TO-above(TO))/above(TO)

could be enough.

Format percentage in numbers tab, if you like.

Regards,

Stefan

[mphekin12]

Stefan,

Your solution is much cleaner. Thanks for the suggestion!

Mike