Implementating a CAGR calculation in cube view

Could this not be done using a DynamicCalc member?
DynamicCalc just retrieves the corresponding end_value & beg_value using GetDataCell, into two numeric variables.
And then do the math (where you have the Math.Pow function : https://learn.microsoft.com/en-us/dotnet/api/system.math.pow?view=net-7.0 )