Hi, per the screenshot below, I wanted to calculate a compounded growth rate for 3 years based on quarters. Let's say user selects Qtr 20131 all the way to 20143. the formula that i use is
=pow(sum({$} Total_Sales)/Sum({$<QuarterID = {">=$(=Min(QuarterID) - 12)<=$(=Max(QuarterID) - 12)"}, Fiscal_Year =, Fiscal_Qtr = >} Total_Sales),(1/3))-1
however, it is only calculating it by quarter for example for 20143, it is taking ((1,000 / 0)^(1/3))-1 which gives me error. and so on... What i wanted is to take current sales for the quarter selected by user and compare that to sales at 12 quarters back (in QuarterID) to get the answer.
is this doable? Can someone help please?
thanks!
![](/legacyfs/online/63192_pastedImage_1.png)