Skip to Content
0
Sep 28, 2020 at 02:37 PM

CAGR in SAP Analytics cloud

227 Views

Hi Experts,

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?

Thanks,

Vamshi

Attachments

cagr.jpg (141.3 kB)