Custom Statistics CAGR

[#1]

Hello,

Im trying to build a custom statistic, what i'm trying to accomplish is to get the CAGR (compound annual growth rate) for a chart that i'm displaying. What i need to do is to get the value from the last year, the first year and the number of years in between. Then apply a mathematical formula and display a value.

I dont know if it is possible to do a custom statistic, or use a table, etc.

Thanks in advance!

[CBRZ]

Thanks for this, works great!

If I were to put set analysis within this CAGR, where would I put it?

I'm trying to make [Version] = 'Budget'

Thanks for your help!