-
SUMProduct in Excel
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 (which is the starting month for their calculation) to the End of the month of the calculation engine but backwards. Let me…
-
Level 2 Sprint 3
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 Sku details'.'Distribution center] is this correct?
-
LEVEL02 SPRINT 3 : Calculation problem
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 imported (65). Then when i multuply this amount by Final shipping amount 8149 i get 532610 ijnstead of 529685 like presented in…
-
Planual Explained - Day 7
"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 is more efficient than storing text fields”. It goes against P elements of PLANS if you wish to do so. Here is how it was…
-
Planual Explained - Day 20
"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. So, the expression should be: 'Calc line item' = 'data line item' + PREVIOUS('Calc line item') rather than CUMULATE('data…
-
End User Insert List Item
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. They have full access to all Lists & modules Thanks Mark
-
Level 1 Model Building: EMP01 Employee Drivers import
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 correct csv file for import, but the one thing I can't get right is the time that it's asking me for. It's asking me to…
-
Boolean Filter to match List Subset and List in Module
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 L2 column in SYS Module, then the Expected Result is that Serv under North Track and Serv under East Track should appear…
-
SELECT command does not work with Version name having number in its name
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 unlike EOQ1 (It consists of text and number). 1st formula works well unlike the 2nd one which gives Inval. I believe its a bug…
-
Rank Function (Two Dimensions)
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 value (net negative suspense). I want to display the top twenty customers having negative values on a dash, but I'd like it…
-
Level 2 Sprint 3 INV01 - Not 1st week of Timescale?
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. Whatever i try to generate for this lineitem is based on the current period of the timescale. What i am trying to understand…
-
Planual Explained - Day 19
"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 FINDITEM(List, Text) ELSE BLANK. It goes against PERFORMANCE, NECESSARY elements of PLANS if you wish to go against this rule…
-
May 2020 Release Updates
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 Community There are a lot of features that are released but here are the details about some of the amazing features released in…
-
Referencing values across Versions
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 has been completed I'm created a module dimensionalised by Customer Account & Versions which returns a Boolean if the Customer…
-
Sum on Clone Day Period List
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 Day List as a property Source Data dimensionaled by Time(Day) Target module dimensionalised by Clone Day List and referencing…
-
Formula to pull data from one member to another of the same list
Hi What formula does one use to pull data from Member1 to Member2 of L1 L1 |-- M1 - 10,000 |-- M2 or from Actual to Budget ?
-
LEVEL 2 SPRINT 2 format issues
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
-
Known Issues with using POST and IF??
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 from the current period in a line item to another line item x periods ahead under a certain condition. IF Condition is…
-
Line Item Subsets and COLLECT() function with calculated % Values
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 the % value of one line vs another Line Item (% calc, summary is set to formula) in the same Module. I've created a…
-
NEW UX: Easily create New board / worksheet page option at the bottom of a category
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 category (i.e. the red box on the Screenshot) In my example, clicking the red box should allow me to 1. choose a page type, 2.…
-
ANY Summary on Time - Day Dimension
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 using ANY for Time Summary if the Time - Months dimension is used but there seems to be an issue when using Day Any ideas…
-
Best Practices for to define list in Properties vs Modules
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 Pack Types (Small, Medium, Large) and calculations based on these inputs. I thought I read it somewhere that it is better to…
-
Planual Explained - Day 18
"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 intermediate relationship calculations especially if Time is a dimension or when the source and target structures are very different.…
-
Weighted average, similar to sumproduct in excel
Hi all I have 4 line items vis. Actual demand, D1, D2,D3, Forecast demand. Having monthly time dimension for FY 20. Need to calculate Forecast demand for each month based on this calculation Forecast for April 20 = (Actual demand for Jan 20 * D1+Actual demand for Feb 20 * D2 + Actual demand for Mar 20 * D3)/ sum D1 +D2+D3…
-
Transportation Planning
Hi, I am looking for a standard demo or Model for transportation planning published by Anaplan which is accesible to all. Thanks and regards Ruchir
-
How to aggregate of data with different dimensions across modules.
Hi everyone. I have two modules. Each module has different dimensions. And I would like to aggregate these modules to one modules. Please see below: I assume that it will be solved by importing data between modules. But I don't know the specific solution. How can I solve the problem? Best regards, Taku
-
Version Budget formula
Hi The Current Fiscal Year is Jan 2020 to Dec 2020 No of Past Years : 1 No of Future Years: 1 Current Period: changes monthly For a Sys module, what formula (Boolean type) can be used to select the months for Jan 2020 to Dec 2020 (even though Current Period changes)?
-
Module line item formula not working
Hi I am trying a simple formula to populate the line item 'Destination Org (Source)' in my module 'Comp Incoming PR/PO'. The formula is comp_pro_po_supply.Destination Org. Any help is appreciated. Thanks Regards Prabakaran
-
Planual Explained - Day 17
Below rule is connected to the rule explained in Planual Explained - Day 16 - Anaplan Community Go through it before you read further. "Rule 2.02-05": Article 2, Chapter 2, and Rule 5 – “Create “joins” in smallest hierarchy”. “If a text string join is needed, create the joins in the smaller hierarchies first to minimise…
-
Item name must be mapped-error message
Hi I have the list comp_pr_po_supply and trying to import data from the datafile in my computer. During mapping, I am getting the message ,Item Name must be mapped for the property comp_pro_po_supply. I assume I am getting this message because comp_pr_po_supply has been setup as a list item. But, I don't find that in my…