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
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....
thanks for the solution Sunny Talwar
Retrieving data ...