20 Replies Latest reply: Nov 10, 2015 12:21 AM by Yeo Poh sai

Expression for cal CGAR ?

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

• Re: Expression for cal CGAR ?

So are you looking to get Year-over-Year sales growth?

• Re: Expression for cal CGAR ?

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

• Re: Expression for cal CGAR ?

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?

• Re: Expression for cal CGAR ?

Hi Sunny

I need the expression at front end. I want to compare sales growth by company.

Paul

Sent from my iPhone

• Re: Expression for cal CGAR ?

Hi All

The QVW file last night i upload is very complicated , This time i try to upload the simple one.

Hope some one can advise me how to get the value of CAGR for 2010 till 2015.

Paul

• Re: Expression for cal CGAR ?

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

• Re: Expression for cal CGAR ?

Hi Paul,

Try to convert my fields with your existing fields.

Here I am not able to open your QVW.

Thanks

• Re: Expression for cal CGAR ?

Hi QV 9977

I just upload a new QV doc ver 007

Can you pls take a look sure can open

Paul

Sent from my iPhone

• Re: Expression for cal CGAR ?

Hi Paul,

=((pow((((SUM({\$<year=,year={\$(=max(year))}

>}[sales]))/100000)

/

((SUM({\$< year=,year={\$(=max(year-4))}

>}[sales]))/100000)),(1/4))-1)*100)

I thing you have to create master calendar in your data model in proper way...

• Re: Expression for cal CGAR ?

Hi QV7799

I have apply your expression into my table , i found that the result is wrong.

Base on cal is 18% but your display -219%

Paul

• Re: Expression for cal CGAR ?

• Re: Expression for cal CGAR ?

Hi QV7799

I have file attachment ver002 of my QV DOC , in side you can see my expected result 18%

Paul

Sent from my iPhone