Calculation of yearly growth for several areas

I love the "if then else" function - maybe to much.
My problem is that I would like to calculate growth from one year to the next for, let say, 7 years in a row for different areas. 

To to this I create a dummy variable (accumulated count members). I use this dummy to define in wich row I want growth from 2011 to 2012 to appear. It used to work just fine, but now for the case in question, the formular seems to be to long and I can only get 3 years growth. I imagine there must be a better way to do this. 

Can anyone help me?

Eg. Current formular: if sum(c2, 0, m1) = 2 then (sum(0, d-5, m1) - sum(0, d-6, m1)) / sum(d-7, d-6, m1) else if….. (continues *9)



  • Can you upload and example cross table to show what it is you mean?

  • I think I just figured it out - I can use "sum(0,0, m1) - sum(0,-1,m1)" that makes it much more simple!


Please sign in to leave a comment.

Didn't find what you were looking for?

New post