topic Re: Anaplan Calculation Order of Operations in Anaplan Platform
https://community.anaplan.com/t5/Anaplan-Platform/Anaplan-Calculation-Order-of-Operations/m-p/59721#M10691
<P>Indeed Anaplan removes the un-necessary parenthesis when are used logical or mathematical operators that have the same priority.</P><P>I was surprised as well in the first place when I noticed this. </P><P> </P><P>I think this has to do with the optimization of the Anaplan calculation engine in order to parallelize as much as possible.</P><P> </P><P>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. </P><P> </P><P> </P><P> </P>Thu, 06 Feb 2020 16:41:09 GMTalexpavel2020-02-06T16:41:09ZAnaplan Calculation Order of Operations
https://community.anaplan.com/t5/Anaplan-Platform/Anaplan-Calculation-Order-of-Operations/m-p/59236#M10378
<P>I am trying to write a simple formula and Anaplan keeps removing the parentheses which causing an issue with the order of operations needed.</P><P> </P><P>What am I missing here? Do I have to break out both parts into separate line items or is there a syntax issue?</P><P> </P><P><SPAN>Desired: ('Total Units (Final)' </SPAN><SPAN class="bpx-highlight bpx-math">/</SPAN><SPAN> Total Units) </SPAN><SPAN class="bpx-highlight bpx-math">*</SPAN><SPAN> ('Qty1' </SPAN><SPAN class="bpx-highlight bpx-math">/</SPAN><SPAN> Qty Final)</SPAN> </P><P> </P><P><SPAN>Result: 'Total Units (Final)' </SPAN><SPAN class="bpx-highlight bpx-math">/</SPAN><SPAN> Total Units </SPAN><SPAN class="bpx-highlight bpx-math">*</SPAN><SPAN> 'Qty1' </SPAN><SPAN class="bpx-highlight bpx-math">/</SPAN><SPAN> Qty Final</SPAN></P>Mon, 03 Feb 2020 23:37:31 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Anaplan-Calculation-Order-of-Operations/m-p/59236#M10378mooreta2020-02-03T23:37:31ZRe: Anaplan Calculation Order of Operations
https://community.anaplan.com/t5/Anaplan-Platform/Anaplan-Calculation-Order-of-Operations/m-p/59239#M10380
<P>Hi <LI-USER uid="12605"></LI-USER> ,</P><P> </P><P>Anaplan is probably doing this because results are same in both the case.</P><P>Are you seeing any difference in results??</P><P> </P><P>I tried both approaches in spreadsheet and the results seem to be same.</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Yash1_0-1580774035068.png" style="width: 400px;"><img src="https://community.anaplan.com/t5/image/serverpage/image-id/28820iD43E1E1219D32565/image-size/medium?v=v2&px=400" role="button" title="Yash1_0-1580774035068.png" alt="Yash1_0-1580774035068.png" /></span></P><P> </P><P>Thanks,</P><P>Yash</P>Mon, 03 Feb 2020 23:54:36 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Anaplan-Calculation-Order-of-Operations/m-p/59239#M10380Yash12020-02-03T23:54:36ZRe: Anaplan Calculation Order of Operations
https://community.anaplan.com/t5/Anaplan-Platform/Anaplan-Calculation-Order-of-Operations/m-p/59248#M10388
<P>Hi <LI-USER uid="12605"></LI-USER> ,</P><P> </P><P>As per my understanding, the simple mathematical order of operations(<I><STRONG>"Operations"</STRONG></I><SPAN> mean things like add, subtract, multiply, divide, squaring, etc.), is </SPAN></P><P> </P><TABLE border="0"><TBODY><TR><TD width="60"><DIV align="center"><STRONG>P</STRONG></DIV></TD><TD><STRONG>P</STRONG>arentheses first</TD></TR><TR><TD><DIV align="center"><STRONG>E</STRONG></DIV></TD><TD><STRONG>E</STRONG>xponents (ie Powers and Square Roots, etc.)</TD></TR><TR><TD><DIV align="center"><STRONG>MD</STRONG></DIV></TD><TD><STRONG>M</STRONG>ultiplication and<SPAN> </SPAN><STRONG>D</STRONG>ivision (left-to-right)</TD></TR><TR><TD><DIV align="center"><STRONG>AS</STRONG></DIV></TD><TD><STRONG>A</STRONG>ddition and<SPAN> </SPAN><STRONG>S</STRONG>ubtraction (left-to-right)</TD></TR></TBODY></TABLE><UL><LI><SPAN>Divide and Multiply rank equally (and go left to right).</SPAN></LI><LI><SPAN>Add and Subtract rank equally (and go left to right)</SPAN></LI></UL><P> </P><P><SPAN>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.</SPAN></P><P> </P><P><SPAN>Hope this helps.</SPAN></P><P> </P><P><SPAN>Thanks ,</SPAN></P><P><SPAN>Jitendra </SPAN></P><P> </P><P> </P>Tue, 04 Feb 2020 04:46:51 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Anaplan-Calculation-Order-of-Operations/m-p/59248#M10388Jitendra.Vishnolia2020-02-04T04:46:51ZRe: Anaplan Calculation Order of Operations
https://community.anaplan.com/t5/Anaplan-Platform/Anaplan-Calculation-Order-of-Operations/m-p/59318#M10412
<P>Thank you both. Seems I can't remember 5th grade math well.</P><P> </P><P>I saw the parentheses removed and thought that was the issue. My calculation was incorrect in the first place.</P><P> </P><P>Thanks again!</P>Tue, 04 Feb 2020 13:22:19 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Anaplan-Calculation-Order-of-Operations/m-p/59318#M10412mooreta2020-02-04T13:22:19ZRe: Anaplan Calculation Order of Operations
https://community.anaplan.com/t5/Anaplan-Platform/Anaplan-Calculation-Order-of-Operations/m-p/59721#M10691
<P>Indeed Anaplan removes the un-necessary parenthesis when are used logical or mathematical operators that have the same priority.</P><P>I was surprised as well in the first place when I noticed this. </P><P> </P><P>I think this has to do with the optimization of the Anaplan calculation engine in order to parallelize as much as possible.</P><P> </P><P>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. </P><P> </P><P> </P><P> </P>Thu, 06 Feb 2020 16:41:09 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Anaplan-Calculation-Order-of-Operations/m-p/59721#M10691alexpavel2020-02-06T16:41:09Z