how to calculate cagr where difference in years is provided by user via variable?

[Anonymous]

i have a variable named diffyear which would be given by user

The beginning value should be calculated using diffyear

cagr=((end value/beginning value)^(1/diffyear))-1

i only want to find cagr for three years.I have used below but it gives last value null

[sunny_talwar]

Is below giving null because you have only selected 3 years? If that is true, then all you need to do is to ignore selection in year field within the expression you use inside below....

[Anonymous]

thanks for the solution Sunny Talwar