7 Replies Latest reply on Jul 25, 2018 3:02 AM by Daniel Higgins

# 1% Growth Calculation

I'm trying to create a calculated field that will look at a row of data 2018 - 2028 and will apply a 1% increase year on year (apply a 1% increase to the previous number in the calculation) and show this as another line on the chart. (header 3)

Does anyone know what the calculation would be?

Example

Year Number of StaffNumber of Staff +1%
2018

100

101
2019

100

102
2020100103
2021100104
2022100105
2023100106
2024100107
2025100108
2026100109
2027100110
2028100111
• ###### 1. Re: 1% Growth Calculation

Hi Tom,

I have taken the sample data set as you mentioned above

Create a calculated like below

Hope this helps

Kindly mark this answer as complete or helpful so that it will help others

1 of 1 people found this helpful
• ###### 2. Re: 1% Growth Calculation

Hi TOm,

You can use below logic to calculate 1 %:

sum([Number of Staff (copy)])+INDEX()

1 of 1 people found this helpful
• ###### 3. Re: 1% Growth Calculation

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?

• ###### 4. Re: 1% Growth Calculation

in place of Index() replace with index()*5

• ###### 5. Re: 1% Growth Calculation

Hi,

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?

• ###### 6. Re: 1% Growth Calculation

Hi Daniel,

Check the below calculation

it will add 5% to every year when compared to previous year

Hope this helps

Regards,

BN

• ###### 7. Re: 1% Growth Calculation

Hi BN,

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 100

100 105

100 110.25 (5% of 105)

100 115.76 (5% of 110.25) etc

100 121.55

100 127.63

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!

Danny.