cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

CAGR calculation

Hi,

 

Wish to calculate CAGR of each client for the last 5 Years, 've a data set in the below format(Sample), The data starts from Fy14 till YTD. Please advise the process and formulas to calculate the same.

 

Date                   FY       Revenue      client

11/01/2018      FY19      $600             A

12/01/2018      FY19      $12514         B

01/01/2018      FY19      $51214         C

02/01/2019     FY19       $545415       D

 

Regards,

Varun

 

 

 

 

1 REPLY 1
Community Support Team
Community Support Team

Re: CAGR calculation

@chandra_0202 ,

 

What does "CAGR" mean? Are you trying to achieve YTD or other results? Could you post calculate logic and the expected result?

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.