1 of 1 people found this helpful
You can use below logic to calculate 1 %:
sum([Number of Staff (copy)])+INDEX()
Thank you so much, this has really helped me out! What I don't understand though is how it knows its 1% year on year. How would the calculation look if I wanted to increase by 5% year on year from the previous?
in place of Index() replace with index()*5
I'm trying to do a similar thing however this solution seems to add 1 to every year, not 1%. Another user has suggested using Index*5 if you wanted to show a 5% growth year on year, but this just adds 5 each year, not 5%.
It looks as though INDEX acts like RANK and just adds 1 to every row, from what I've read?
I'm missing something obvious?
Many thanks for your reply.
This works (which is a great solution), however, there is one slight change we need. Apologies, I probably didn't explain it very well originally.
The 5% growth needs to look at the previous year, rather than 5% of 100 every time.
For example, the data would look like this:
100 110.25 (5% of 105)
100 115.76 (5% of 110.25) etc
The changes look minimal in this example, but our actual data set is in the tens of thousands so it makes a big difference.
Thanks again for any help!