Anaplan Percentage Format Issue

Monpero · 2023-06-11T13:27:20+00:00

There was an error rendering this rich post.

Monpero

Hi All,

I am trying to calculate the Compound annual growth rate (CAGR) in Anaplan and I am getting a 100% instead of 1%.

Here is the formula logic in excel =((Z84/C84)^(1/23)-1)

The first value is cell=(C84) January 2021 value = -167,217
The last value is cell=(Z84) December 2022 value = -136,485

The Cost values go across January 2021 - December 2022

In Anaplan used this logic :-

End Value = December 2022 value = -136,485

Starting Value = January 2021 value = -167,217

BB CAGR = POWER(End Value / Starting Value, 1 / 23) - 1

In Excel it resolve to -1% throughout the line item which is expected, but in Anaplan I get -1 but when I format the to percentage then it changes to -100%.

Please does anyone knows why it does that and how can I make it to show -1% instead of -100%. Please this is urgent for me, any help will be appreciated.

Number format

But when formatted to percentage, it shows -100% instead of -1%

Accepted answers

All comments

BenjaminNiel

Hi,

I doesn't seem to come from the POWER function as it works for me:

Are the 2 values (-167,217 & -136,485) referring to the same month in your module?

Could you please share a screenshot with: the starting & ending value line items and the formula using Power?

Thanks!

Puneeth H P

Hi @innocent

Anaplan considers -1 as -100% only. So, if the desired answer is -1%, then divide the final "-1" CAGR value by 100, which is -1/100 ( -0.01), and then try to change the format. Which will give you -1% when changed format.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…