Custom Formula - Incorrect Calculations

06-11-2020 10:12 AM
New Contributor II

Hello everyone and anyone,

I am working out of Business Analyst Web App attempting to build a Custom Variable containing a compound annual growth rate (CAGR) formula into one of my Custom Infographic Reports.

The CAGR Formula attachment shows the calculation I wish to perform. The Pet Spending CAGR attachment shows the formula I have built in BA Web App (I have built this formula out many different ways and am burning credits trying to find a formula that will work). My suspicion is that the the exponent is not functioning correctly as it displays as " ** " instead of " ^ " when you hover over the infographics output. 

Any advice/suggestions would be greatly appreciated.



0 Replies