Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

 

 

 

 

Need Help

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Anonymous ,

     

    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.