I am trying to replicate what we did in excel to find a 3 year CAGR (compounded annual growth rate). I created a measure called CAGR in Account Dimension with a formula:
CAGR([Gallons] ,[d/Date],"2018" ,"2020" )
I included this account in my story but see a -100% for all members. What am I doing wrong?