This content has been marked as final.
Show 3 replies

1. Re: Calculating a growth rate between two given years
Zhouyi Zhang Sep 8, 2017 12:17 AM (in response to Deepak G S)1 of 1 people found this helpfulHi, 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

2. Re: Calculating a growth rate between two given years
Jonathan Drummey Sep 8, 2017 8:21 AM (in response to Deepak G S)1 of 1 people found this helpfulIf 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

3. Re: Calculating a growth rate between two given years
Deepak G S Sep 10, 2017 2:24 AM (in response to Jonathan Drummey)Thanks ZZ and Jonathan happy weekend