Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

CAGR Calculation

Hi,

 

I 'm Looking for a solution to Calculate CAGR. refered to many blogs still could not get the solution. Pease find the sample data below, I wish to get the client growth over the period, my FY starts from Apr-Mar. My data consists of  Date column and FY represented as "FY17, FY18" which is a text format. please help me proper formula to calculate CAGR every Year.

Please let me know if you need further details.

 

Regards,

Varun