Anaplan Calculation Order of Operations

I am trying to write a simple formula and Anaplan keeps removing the parentheses which causing an issue with the order of operations needed.

What am I missing here? Do I have to break out both parts into separate line items or is there a syntax issue?

Desired: ('Total Units (Final)' / Total Units) * ('Qty1' / Qty Final)

Result: 'Total Units (Final)' / Total Units * 'Qty1' / Qty Final

Accepted answers

All comments

Yash1

Hi @mooreta ,

Anaplan is probably doing this because results are same in both the case.

Are you seeing any difference in results??

I tried both approaches in spreadsheet and the results seem to be same.

Thanks,

Yash

Jitendra.Vishnolia

Hi @mooreta ,

As per my understanding, the simple mathematical order of operations("Operations" mean things like add, subtract, multiply, divide, squaring, etc.), is

P	Parentheses first
E	Exponents (ie Powers and Square Roots, etc.)
MD	Multiplication and Division (left-to-right)
AS	Addition and Subtraction (left-to-right)

Divide and Multiply rank equally (and go left to right).
Add and Subtract rank equally (and go left to right)

Thus in your case for the Multiplication and Division the ranking is equal. That can be a reason the Parenthesis are being removed. If you try with some other operations Like Multiplication and Addition then the Parenthesis will not be removed.

Hope this helps.

Thanks ,

Jitendra

mooreta

Thank you both. Seems I can't remember 5th grade math well.

I saw the parentheses removed and thought that was the issue. My calculation was incorrect in the first place.

Thanks again!

alexpavel

Indeed Anaplan removes the un-necessary parenthesis when are used logical or mathematical operators that have the same priority.

I was surprised as well in the first place when I noticed this.

I think this has to do with the optimization of the Anaplan calculation engine in order to parallelize as much as possible.

When parenthesizes are present, the calculation engine is obliged to follow a particular order of the calculation... without them, Anaplan can calculate in parallel (so quicker) some parts of the formula and returning, in the end, the same result.

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
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…