3 Replies Latest reply on Sep 10, 2017 2:24 AM by Deepak G S

# Calculating a growth rate between two given years

Hello All,

Can we calculate a growth rate between 2 given years using Formulas and not the table calculations?

We can use the sample super store data here.

Anyone have any idea on this?

Regards,

Deepak

• ###### 1. Re: Calculating a growth rate between two given years

Hi, Deepak

There are lots of ways to use calculation to achieve this. Not sure what's the end result you would like to display, but below calculation may give you some ideas.

Hope this could help

ZZ

1 of 1 people found this helpful
• ###### 2. Re: Calculating a growth rate between two given years

If the years are dynamic and you want the latest two years then ZZ's post is perfect.

If they're fixed then it can be simpler:

2014 Sales

IF Year([Order Date]) = 2014 THEN [Sales] END)

2015 Sales

IF Year([Order Date]) = 2015 THEN [Sales] END

Growth Rate (% Difference)

(SUM([2015 Sales]) - SUM([2014 Sales])) / SUM([2014 Sales])

Jonathan

1 of 1 people found this helpful
• ###### 3. Re: Calculating a growth rate between two given years

Thanks ZZ and Jonathan happy weekend