I need help I am getting negative numbers for my beginning inventory and the week 1 comes off as a 0. On top of that the "Override Suggested Order Amount?" Boolean is not allowing me enter anything ev…
Hello, During my training, I had to build the Inventory ordering module for the supply chain model (level 2). After building it following the instruction, I'd like to test new formulas to determine th…
Hi friends, I am having a issue related to list items. As shown below, I have a list with items a, b, c, d. I have used this list as a dimension in a module which has value(number formatted) line item…
Dear Experienced Anaplanners, I am at Level 2 Sprint 2 trying to use formulae to add data to Demand modules. As per the lesson, I've created DEM01, DEM02 and DEM03 modules. DEM01 and DEM02 are Volume …
Given: End user can input in the following 9 columns as a dropdown(List Format) in the Input Free Form. Free Form is a module having a Numbered List applied which is having these Line Items as a List …
Hi Community, I would like to ask if this is possible. There are 3 modules done but 1 module is set to monthly and the other is set to quarterly. See below for the illustration: I had to create an ill…
Hi, I have a question on the LI "Initial Country Sales Targets" in Module TAR01 Detailed Sales Target. For this line item I'm assuming that we are pulling from the TAR01 Sales Targets where the initia…
Hello, I can use item(user list) to get current user, i.e. the user who login current system, it requires to use user list as dimension. Now I have a module which is not dimensioned user list, is it p…
Quite literally what the title says. I am able to point and click on the different features just like a regular list, or I can apply the User List for specific roles to reduce sparsity. There are adva…
Anaplanners, For an input screen, I want to enable users to input at a yearly level and then I want that same value to flow to every month pertaining to that year automatically. This is to make life e…
Custom Time Aggregate Filter and Selector by @JohnB & @ShaneenW We present our approach to creating a custom time aggregate filter and selector. We look forward to learning a more efficient approach t…
Hi Everyone, Can anyone help me to understand, how we are calculating the module size in GB format? If I want to see the actual size of my modules in GB then, do i need to enable any option in Anaplan…
Hi Anaplan, It would be amazing if within the drill down view you were able to filter on a list of values for items that are non blank or non zero. So for example if you're looking at a calculation wi…
Hi guys as the subject, I want to get the Index of a Numbered List Item, what attribute/property should I use? the Propeties I've tried: (Item )Index (Item )ID (Item )Number (Item )suffix by the way, …
Hello, There are similar posts on this topic, but none of the solutions seem to work. I am trying to create an inventory calculation that allows the user to delay/push production to subsequent periods…
Hi There is a requirement that we need to sum list items total to a specific list item in the same list based on some selections User selects Yes/no one line item(drop down) and Revenue method on anot…
I need help, I’ve been on this section for a couple of days and can’t seem to figure out why my data is not populating. My formulas are correct but I’m not understanding.
Hi, What formula can be used to get the code of a parent list inside a flat module? for example in this particular module the parent is a numbered list and I want to bring its code in the 'Code' line …
Hi Anaplan Community, I have been thinking of ways to pull Prior Year value into Current Year. Previously, I used OFFSET() formular where I would offset -52 weeks. I have created a demo module below t…
Hi All, Just wanted to clear some doubts on usage of SUM & LOOKUP at the same time for same line item If I use SUM & LOOKUP both at the same time for the same line item, its giving me correct details …
@noelle_murphy Hi, can I set up a 1:1 with you? Some of my formulas in lesson 6 aren’t working & it’s hard to move on from that. I also sent you an email. Thank you
Anplanners, I have a Module (XYZ) Dimensioned by GL (Row Headers), Cost Centers L3 as selectors and few Line items to determine the total amount. Aim is to get input at GL level for each Cost Center. …
Just wondering is there a way to find duplicates where the cell count is more than 50 million and I know in Polaris engine it is possible. Any other way to do it in the classic engine ?
How would you use a select formula to collect totals for For example I want to fill the base opex row with numbers from this module below (totals only) What formula would I use? Thanks
Hello All, I've used the SUM function to map region and role into 'EMP02 Employee Expenses'. I've been going through my formula and the source modules for quite some time now yet the formulas still yi…
I am having trouble checking my formulas. My Shipping Method & shipping time weeks is not showing up and I think it is because in the SYS 08 SKU Details the distribution center is not showing up. It i…
Let's say I have column username where the drop down is a list. A username is "JonSmith-81". I'd like the next line item, lets call it alias, to just pull "JonSmith" from this string. The alias line i…
