Hi, I have a module with 3 different list formatted LIs and an amount line item. I want to sum the amount in the module basis these line items such that any list item that has these 3 properties simil…
Hi, I've got a list of products A - Z, and within some of these products, it contains several products. Most products are like product A below, only some are like product B. What is the best way to fo…
Hi All, We have created a Dynamic Scenario List as #Numbered List. Parent List is the Planning Stage list for which they are creating the scenarios. Now we have given a functionality to add any Scenar…
Hi, Request guidance on how SUM can be applied based on condition: Objective: Get average difference between invoice and receipt date by customer for Cleared Lines only Model structure: 1. Customer (l…
“Rule 2.02-12": Article 2, Chapter 2, and Rule 12 – “No Hardcoding to List Members”. “Avoid direct references to list item. E.g. IF ITEM(list) = list.xx. It goes against SUSTAINABLE elements of PLANS …
Hi Guys, I would like to ask help on this issue that I have never encountered before. In the clients excel sheet they are using a SUMPRODUCT formula. The Logic is multiplying the Start of the month (w…
for Inv03 distribution center summary, line item 'stock exceptions' to show total number by Distribution center I use this formula: Inv01 inventory ordering.safety stock exceptions count[Sum: 'sys08 S…
Hello, I am having issues calculating the shipping costs. I thought that my formula wasn't working but it's working perfectly . You can check with SHipping cost per 1000 that the value is correcly imp…
"Rule 1.05-12": Article 1, Chapter 5, and Rule 12 – “Use formulae to derive property of the list”. Based off the code of the list it should be possible to derive the properties, calculating the values…
"Rule 2.02-10": Article 2, Chapter 2, and Rule 10 – “Using PREVIOUS vs CUMULATE”. “For long timescales, using PREVIOUS is faster than CUMULATE due to the number of "reads" required for the calculation…
Hi Team, Can an End User Insert a List Item for a General List (not Numbered list) through the + button? We have the List published to a Dashboard but the + button is not visible to the End Users. The…
I've been working on the Level 1 Model Building course and I'm a bit confused by this import. I'm sure I have followed all the directions exactly from setting up the EMP01 module to downloading the co…
Hi I am trying to create a filter to apply to 'INP Module - No of Frequencies' so that result below can be achieved but am hitting humps. If the North Track and East Track in 'ss NE' matches the Track…
Hi, I was working to find products ASP for a Version with a variance of 10% between product ASP in other Version. For example, product ASP outlier with version BOQ(Beginning of Quarter) works well unl…
Hi, I have a module with two dimensions (besides time): customer (BA) and sales location (plant). I'm looking to use the RANK function to display the top twenty customers for a specific line item of v…
I have a question on the line item Not 1st week of Timescale? in the "SYS01 Time Settings By Week' module of Supply Chain Model. I am trying to understand the formula for First week of the timescale. …
"Rule 2.02-15": Article 2, Chapter 2, and Rule 15 – “FINDITEM on blanks”. “If the list being referenced does not contain blanks, there is no need to check for blanks with IF ISNOTBLANK(List) THEN FIND…
May 2020 Release Updates Did you check out the latest features released in May 2020. Here is the link for full updates and a sneak peak at June May 2020 Releases and Sneak Peek at June - Anaplan Commu…
Hi Team, We upload our full SF account list to our Customer Account list at the start of the planning cycle and I wish to delete out accounts which do not have revenue in any versions once the Plan ha…
Hi Team, I have created a Clone Day Period list as I require to RANK data that is dimensionalised by Day but I cannot SUM the data into the Clone list when using the mapping Time(Day) with the Clone D…
Hello I have a format problem in this module. Instead of having 58.88 for example like @Lkishko , i have 5,887,728... like shown below : Insted of having this format : Any help ? Thanks Younes
Hello everyone, @Misbah @JaredDolich @rob_marshall If you know there is an issue with using POST with IF then please let us know, if you don't please read on. Context: We would like to move a value fr…
Hi Everyone, I have a reporting requirement which I cannot seem to perform due to limitations on Line Item Subsets and the COLLECT() function. I have a Line Item from Source Module A which calculates …
When building out pages in the New UX, it would make things much smoother on the builder if you provided a "Create New Board Page" / "Create New Worksheet Page" under the last item of a predefined ca…
Hi Team, I have a module dimensionalised by Time - Day & have a Boolean line item where I need to be able to set the Time Summary to ANY but I keep receiving an error when I try There is no issue with…
Hi experts I am looking at the benefits of defining list in Properties and Modules. Eg. The Pack Type Size members (Size) are to be tied to a SKU. There will be inputs at Size (100g, 200g etc) and Pac…
"Rule 2.02-08": Article 2, Chapter 2, and Rule 8 – “Never use SUM and LOOKUP together”. “SUM and LOOKUP used in the same expression generally cause large formula calculations and may cause intermediat…
