Modeling

Converting Serial Number to Data Format
Hi, How can i convert serial number to date format in Anaplan? Thanks in advance for helping. Tom
Problem with replacing SELECT with LOOKUP
Hi everyone, I am replacing SELECT functions with LOOKUP as a part of model optimization (2.02-14 Avoid using SELECT). I did it lots of times and they worked but I am struggling with couple of them. My approach is that I use mapping module to use LOOKUP instead SELECT. I add list formatted line item and select the list…
Invo5 shipping costs
The above image show what has to be done I have attach the data i am getting for shipping cost is wrong I am not able to rectify please help me out what i have done wrong .
Import from Subsidiary View
Does anyone know a workaround to import from a subsidiary view?
MB 1 13 6 4 and 13 6 5
Community, Working through MB 1- on lesson 13 now to set up UX pages. The results of my first attempt at a Volume Chart, followed by Margin Chart result in something not desired. The line graphs follow along the periods then comes the full year values. The full year values make the visualization unusable from an end user…
INV01 Level2
I have attached screenshot ,what booleans I must have checked in INV01 so that my module will be ready for further calaculatons or whatever changes I should made in this module to make it calculation ready.
Level 2 Sprint 3 3.3.7.2 Add DCA to INV01 Inventory Ordering
Almost completed the work Just confused regarding my work plz suggest if I am wrong 1. Should I use "Submit Purchase Order Request" line item as formula in AD02 Inventory Ordering for Overrides "Submit Purchase Order - Write? " OR 2. Should I use line item "Submit Purchase Order - Write? " from AD02 Inventory Ordering…
IF THEN statement with Time Dimension
`Hi Team, I have a module dimensioned by Employee Roster and Time. In it I have a line item 'Train/Predict'. In this line item I want to add a formula such that if it's a past time period then Train and for future time period = predict. I tied using the following formula - IF ITEM(TIME) <= Current Month? THEN Train ELSE…
Classic Dashboard - What does this mean ?
Dear Community Members, I am on MB Lesson 12. I have noticed the phrase "........ on a Classic Dashboard or a UX Page" is mentioned frequently in the lessons. I may have missed it from a previous lesson, but I do not understand what the "Classic Dashboard" refers to. Does this refer to the overall Anaplan Platform…
Ability to Select Isolated Cells in Quick Sum Bar
When using the quick sum bar functionality (https://help.anaplan.com/anapedia/Content/Modeling/Navigate%20Anaplan/Quick%20Sum%20Bar.html?_ga=2.86794650.366156822.1550101511-1666663741.1546456255), you are currently only able to select "blocks" of cells (a series of cells in adjacent rows/columns). It would be useful to…
How to avoid Circular Reference
I am looking for a solution on how to write a formula that takes the value for 1 and Jan 21 and adds that value to the answer to the formula in cell 2 and Jan 21. The formula I have currently is the below. What is in bold is what I need to figure out. IF Financial Projection Time = Financial Projection Time.'1' THEN Sales…
Is Something Wrong With my Role List? Level 1
Hi, So while trying to update my Emp02 Employee Expenses module calculations for bonus, car costs, phone costs and medical costs to reference Emp03 Employee Drivers by Role module, I get this error: "Invalid error for 'EMP02 Employee Expenses'.Bonus: Automatic sum of 'EMP03 Employee Drivers by Role'.Bonus % over Role…
'List Item' Scope on Formulae
Would it be possible to implement a 'List Item' scope similar to Version Scope against line item formulae within Anaplan. My thinking here would be to allow some list items to be driven by inputs, and other list items to be driven by a formula. This would be a huge enhancement, but in than vein I am unsure as to how…
MB 1 Activity 11 3 3 Check your work Error (I think)
Working through MB1 11 3 3 I believe the "Check your Work" reference has an error. Looking for a confirmation from experienced Community Member. The activity required that we Set Style Setting to Summary 2 for the Other Costs Line. I would expect that line to be Bold/Indent like that other Summary 2 Style Formatted line…
The ability to select module measurements in Formula scope
Please, add the ability to select module measurements in Formula scope. With this feature you can use both manual input and formula in one LI, not only using the built-in versions, but also the lists and subsets. Advantages: 1. Reducing the number of Line Items. No need to duplicate LI for fact and forecast input. 2.…
Summing based on another modules field
Hi team, Hopefully a straight forward one. I have 2 lists. Campaign and Show ID Multiple campaigns can have the same show however they are not within the same hierarchy. I have a module INP01:Campaign Details that has the Show ID as a line item - not all campaigns have show IDs. I have another module INP02:Episodes where…
Data not matching In inv01 inventory ordering
I am stuck on this module from last 2 day but not getting how to get data correct my formule are correct The image for data what i have got is below
Import data to read quantities per dimension instead of actual data
Hello, I am trying to create an inventory model for a bunch of server farms. i have one csv file with over 15000 machines. For each machine, it shows its location, its manufacturer, the model, how many cpu cores, and a cpu factor. I want to create a module that shows me the average of cpu cores x cpu factor per location.…
Select value from future transaction
Hi, I have a module with a number of transactions for different entities. For all of these entities, I have a Unique ID (UID) and a valid from date. I also have a line item that uses the RANK function to rank the transactions. See picture below. Now to the issue; I need a value in the Valid To line item. This value should…
Sort Line Item Subsets
Description of the enhancement required: Ability to sort line items the same order in the subset as they are in the originating module Example of the enhancement: A Line Item Subset for P&L report that he is using in another module; however, the line items in the Subset are not in the same order as the Line Items from the…
Converting "Month 1" to a date
Hi everyone, I am currently building a project planning scenario analysis UX and have designs that use the line items "Month 1-18" to decide hours available by team. There is a button where we can "create a project" and the "start date" is entered. Is there a way to convert from months 1-18 to actual dates using the start…
DIMENSION INDEXING in POLARIS
If you had already attended an event on 4th Aug 22 by "Modelers Forum India" you would be knowing by now that there is a concept called "Dimension Indexing" in Polaris Engine. In this article we will try to explain what do we mean by Dimension Indexing If you remember, that in Hyperblock any dimension (apart from Anaplan…
Enhance Model list and Manage model information screens
Hi all, We work with many models and workspaces and I often find myself in the need of identifying areas where I can find some space. Unless I'm missing something I often need to actually open the specific workspace in order to check if there's space free there. This is a time consuming activity, therefore : As a model…
List subset from formula
I'd love to have the ability to create a list subset from a formula. That would give a great way to pre-filter and limit sparsity in modules.
Multiple User Editor - New User Experience
As a Page Builder, I would like the ability to be able to have multiple page builders edit the same page at the same time, so we can seamlessly collaborate on editing the same page. Similar to Lucid Chart and Google Sheets, Docs. Sheets. @Misbah @SzaraL @alan @ashwinallen @Google @googlecorp Acceptance Criteria: Me and…
Ability to see when another user has a UX Page open for editing
Since multiple model builders can (and do accidentally) end up opening the same page for editing, when one saves, and then the other saves, someone gets their work lost. It would be very helpful to have an indicator that shows up on a page that would shows me when if someone is already in editing mode on it. I imagine this…
Duplicate a Card on a page
There are times where it would be far quicker for the page builder to simply duplicate a configured card and tweak it (link, columns shown, image shown etc.) rather than create / use a card template or start a new card from scratch. I imagine this could be added to the little ellipsis menu for cards as a natural place. I…
"Missing" argument from "SUBSTITUTE" formula equivalent vs Excel
Anaplan's "SUBSTITUTE" formula has three arguments whereas excel's has a fourth optional argument that would allow for much simpler identification of specific substrings within a string that varies in construct: Anaplan = SUBSTITUTE(Text to search in, Text to find, Replacement text) Excel = SUBSTITUTE(Text to search in,…
Country System Module
Hi Team, I want to ask the Q that on what grounds is the mapping happening Like P3 SKU and G2 country should have the same dimensionality in accordance to Sum fn like we used the systems module to create a list formatted line item? can we do so in all the cases ?

Upcoming Events

Save the Date: Anaplan Workflow - Next Steps in 2026
We’re continuing the conversation! Following the success of our first Anaplan Workflow event, we’re bringing you a deeper look at what’s next. Join us in March as we expand on the insights shared in the previous session and explore how Workflow continues to evolve to support planning collaboration and process efficiency.…
Community Challenge Recap: Annual rollover best practices
In this ACE Spotlight event, we will cover the most effective techniques for making your annual rollovers seamless and repeatable, based on the solutions from our latest Community Q&A Challenge.

Modeling

Discussion List