Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All
i have attend the meeting last 20 year , I keep see people present their sales growth over the year . assume that company operate for last 10 year , and first sales 1 million and 2nd year 2 million and 10 year later this year in 2015 10 million sales.
may I know the expression for CGAR ?
Paul
So are you looking to get Year-over-Year sales growth?
Hi Sunny
http://www.investopedia.com/terms/c/cagr.asp
I am looking for compound annual sales growth rates .
My question is how to create formula , so that I don't need maintain .
Paul
Sent from my iPhone
I know what it means, I am just trying to understand if you are looking to calculate this in the back end or front end of the script? and if you are trying to find the CAGR from min year to max year?
Hi Sunny
I need the expression at front end. I want to compare sales growth by company.
Paul
Sent from my iPhone
May be something like this:
=Num(exp((1/Count(Year)) * log(FirstSortedValue(Sales, -Year)/FirstSortedValue(Sales, Year))) - 1, '#,##0.00%')
Hi Sunny
Can you share with me FirstSortedValue how can get it ?
Paul
Sent from my iPhone
Paul, do you wish to know how FirstSortedValue() function work? Have you seen QlikView or Qlik Sense help?
Check out these links:
Value Associated with Min/Max Value of Another Field (Front End Solution)
go through this https://community.qlik.com/message/821942#821942
Vikas
Try this
=((pow((((SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},MonthName=,Quarter=
>}[Sales]))/100000)
/
((SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear-4))},MonthName=,Quarter=
>}[Sales]))/100000)),(1/4))-1)*100)
This is for five years CAGR