Help with a formula to calculate growth rate

9

in most programming languages the raising of x to the power y is

x^y

in notion this becomes

pow( x , y )

and in Coda it is

Power( x, y )

so your formula
pow

becomes


Round(
    10000 * 
    Power( 
        EndValue / StartValue ,
        1 / Years
    )
    -1
)
/ 10000

max

PS:

The inverse of Power() is Root() but Coda does not have that function.

So, if you do need to get the Nth root of X you need to use

Exponent( Ln( X ) / N )

ie: get the log of X
divide that by N
and use the inverse of Ln(), which is Exponent()
to bring it back to a real number

max

4 Likes