-
Dynamic Table
Hi Guys, I need some assistance on what approach to use here. Below is the description. The clients report consists on a table where they input the No. of Bldgs. and on another report those numbers of bldgs will be spread out. The result on the Target module will be Another example will be and the result on the target…
-
Change Format to % of List subset
Team, Please help how I can change the number format of a list subset to a percentage. Thanks, Tom
-
Standard Deviation: Using no timescale and without current period
Hi Community, I require your help in-order to calculate Standard Deviation. The detailed overview of what I am trying to achieve is described below: I need to calculate Standard Deviation for Daily Sales at Parent Code level for a Depot. My problem stems from that fact that there are no timescales which I can use for…
-
Reference another list in a module dimensioned with one list
My module is dimensioned with a numbered list, let's say Segment>Product#; I'm trying to retrieve the hierarchical parent from another list P2 Product in order to get the product family for each single product. The line item (format 'List') formula I used was to reference directly that list: PARENT(ITEM('P2 Product')).…
-
Planual Explained - Day 22
“Rule 2.02-17": Article 2, Chapter 2, and Rule 17 – “Put the most common condition first”. “For formula efficiency, put the conditional with the most common occurrence first in the formula. It goes against PERFORMANCE elements of PLANS if you wish to go against this rule Here is how it was done in Pre Planual Era: What is…
-
Transfer data from one combination of dimensions to the rest of them
Hi Anaplanners, Let's say we have a module with Dimensions A and B, they have 1000 list members each (for example), and a couple of line items, which user populates manually. Only ONE combination (intersection) of list items has data; the rest of the module is impty. I need to copy this data to all empty cells in this…
-
Level 1 Cert Exam
I am just doing the test now, question is asking about FY21. All my downloads are actual 2019 and budget 2020. Am I missing something
-
Sum basis Multiple Properties
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 similar should show the same value. I know this could be done using sum and lookup but wanted to see if there is a better way to…
-
Hierarchy - roll ups
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 format this hierarchy? or best way so I can view Products A-Z at the top level but also have a breakdown where needed? Product…
-
Level 2 sprint 3 - INV01 inventory ordering Grid
there is an error detected in the highlighted cell please advice how to get this corrected
-
Restrict Adding Numbered List Item
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 Scenario in the #Scenario List. But as the planning stage is closed and locked by the user (Using DCA) all the scenarios get…
-
Sum based on condition
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 (line by line) transactional data stored in a flat (non-dimensional file) 2. Customer lines can have either "cleared" or…
-
Planual Explained - Day 21
“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 if you wish to go against this rule Here is how it was done in Pre Planual Era: Hardcoding to list items used to be a norm.…
-
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…
-
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…
-
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…
-
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…
-
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.…