topic Re: Referencing List Items in Formula in Anaplan Platform
https://community.anaplan.com/t5/Anaplan-Platform/Referencing-List-Items-in-Formula/m-p/143241#M38219
<P>Out of curiosity, how many products/families do you expect to calculate for and with how many different calculation iterations?</P><P> </P><P>There is a way to do what you're looking at, but it typically involves a significant number of nested IFs and if you add a new product, you're back to updating the calculation (I tried to do something similar for a P&L with accounts that had different methodologies.. it was a mess). I also imagine it's going to hit the calc engine hard as well given all the loops.</P><P> </P><P>Without knowing the scope of work, you may be better off calculating in separate modules (using line items + subsets) and then consolidating with your broader list in an output module.</P>Wed, 27 Jul 2022 06:51:34 GMTluke_e2022-07-27T06:51:34ZReferencing List Items in Formula
https://community.anaplan.com/t5/Anaplan-Platform/Referencing-List-Items-in-Formula/m-p/143214#M38211
<P>I have module D03 that shows how many slots each product family uses. D03 is dimensioned by Time on rows, and PR2 Product Family list and 1 line item 'Slots' on columns. I am trying to write a formula that <STRONG>1.</STRONG> references data from another module, and <STRONG>2.</STRONG> does some calculations for all the data in each item for PR2 Product Family. </P><DIV><DIV><DIV><DIV><SPAN>IF</SPAN></DIV><DIV><SPAN> </SPAN><SPAN>ITEM</SPAN><SPAN>('PR3 Product Name') = 'SYS06 Capacity Pointer'.Capacity Pointer</SPAN></DIV><DIV><SPAN>THEN</SPAN></DIV><DIV><SPAN> 'D02 Planned Capacity'.Corrected Capacity / 6</SPAN></DIV><DIV><SPAN>ELSE</SPAN></DIV><DIV><SPAN> 'D01 Slot Forecast'.Slots</SPAN></DIV><DIV> </DIV><DIV><SPAN>The IF and THEN part are for <STRONG>1.</STRONG> It references data from another module and inserts it into a specific item in PR2 </SPAN></DIV><DIV><SPAN>The ELSE part just returns the normal data for the module.</SPAN></DIV><DIV> </DIV><DIV><SPAN>In this case, objective <STRONG>2. </STRONG>does not apply to that specific line item in PR2, so it works perfectly to just enter the calculation in the ELSE part. I am trying to do something like this.</SPAN></DIV><DIV><DIV><DIV><SPAN>IF</SPAN></DIV><DIV><SPAN> </SPAN><SPAN>ITEM</SPAN><SPAN>('PR3 Product Name') = 'SYS06 Capacity Pointer'.Capacity Pointer</SPAN></DIV><DIV><SPAN>THEN</SPAN></DIV><DIV><SPAN> 'D02 Planned Capacity'.Corrected Capacity / 6</SPAN></DIV><DIV><SPAN>ELSE</SPAN></DIV><DIV><SPAN> 'D01 Slot Forecast'.Slots * ('D01 Slot Forecast'.Slots('PR1 Product Lines'.All Products - 'PR2 Product Families'.other))</SPAN></DIV><DIV> </DIV><DIV><SPAN>This doesn't work obviously because in the ELSE part, it is just referencing the list items rather than referencing the data corresponding to the list items in this module. I want the rest of PR2's 'Slots' to calculate </SPAN></DIV><DIV><SPAN>(Slots * (Slots/(Total Slots-Other Slots))</SPAN></DIV><DIV><SPAN>'other' is a list item in PR2 and 'Total Slots' is just the total of all slots in the module (also a list item). </SPAN></DIV><DIV><SPAN><STRONG>How can I reference specific data from the module when writing a formula? I want to make calculations using members of the list. In excel I can just click on a cell and write a specific formula, what would the equivalent of that be on Anaplan? </STRONG></SPAN></DIV></DIV></DIV></DIV></DIV></DIV>Tue, 26 Jul 2022 20:34:58 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Referencing-List-Items-in-Formula/m-p/143214#M38211davargas2022-07-26T20:34:58ZRe: Referencing List Items in Formula
https://community.anaplan.com/t5/Anaplan-Platform/Referencing-List-Items-in-Formula/m-p/143241#M38219
<P>Out of curiosity, how many products/families do you expect to calculate for and with how many different calculation iterations?</P><P> </P><P>There is a way to do what you're looking at, but it typically involves a significant number of nested IFs and if you add a new product, you're back to updating the calculation (I tried to do something similar for a P&L with accounts that had different methodologies.. it was a mess). I also imagine it's going to hit the calc engine hard as well given all the loops.</P><P> </P><P>Without knowing the scope of work, you may be better off calculating in separate modules (using line items + subsets) and then consolidating with your broader list in an output module.</P>Wed, 27 Jul 2022 06:51:34 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Referencing-List-Items-in-Formula/m-p/143241#M38219luke_e2022-07-27T06:51:34Z