Modeling

MR: User to select columns for variance
Hi fellows, New variance feature is a long awaited one. And finally we have it! But this feature is almost a hardcode and it does not allow an end user to select which of the two columns to be compared. Would be great if a user could decide it while presenting something like he can do with page selectors. Or any similar…
stuck on level 1 7 2 3 activity
Hello can you help me please I have a problem with the mapping days not displaying correctly when I select YYYYMMDD. also with the commissions which are displayed at 15 instead of 0.15
In L1 Model Building activity 5, There is an error when updating the Bonus formula in EMP02.
Hi, Can someone help me where am I going wrong. As the error is data type mismatch. Please find below screenshot. Thanks in Advance.
Add column in models Users' list: Enabled (view only)
In Anaplan models, in the Users list, we would like a column "Enabled" that is a view-only column based on the user's Enabled status in the Central Identity Management User Admin (in Tenant Admin). Currently in the Users list in models we lack visibility to whether a specific user has status enabled of disabled in the User…
The four cornerstone
Hey, can anyone help me! I was on lesson 2 of the four-corner stones in The Anaplan Way. I scored 80% in my second attempt, but I have given the quiz 2 times without doing the complete lesson. Now I am stuck and unable to move ahead. There is no checkbox for Second attempt. What to do?
Publish List and there Subset in the NUX
Hi Anaplanners, I have came across problem in which we are migrating from Dashboard to NUX and as of now in NUX there is no facility of publishing list directly, workaround for it would be adding modules and publishing it directly for the list and their properties but what I want to know that in the list we have provided…
Add DCA to INV01 Inventory Ordering- L2 sprint 3
Hi, I am facing doubts in Add DCA to INV01 Inventory Ordering module in L2 Sprint 3 so can anyone please help me how to create DCA formula. It would be great if anyone can help me with this, attaching the course screenshot and the module that I have created according to my understanding.
Users Names
Hello, Can we get the User name in a lineitem if the module is not dimensioned by Users? Thanks Devika
Translating % correct into a RANK()
Hello, Question - I have a module to calculate the percentage correct (e.g. 75%) and I want to be able to rank this on a scale of first to tenth place. Advice on how to do that? I tried using the RANK() with the module calculating the percentage correct and could not get a solid translation. Thanks in advance!
GL's available by Property, Owner, & Expense Category
Hello Everyone! I'm working on a budgeting model and need some help. Happy to provide any necessary details I may have omitted. We have a handful of properties (ownership specific) that need to budget in a specific GL account, while the remaining 90% of properties shouldn't have access to the GL in question. Currently,…
Cannot add Revision tag
Hello, I am trying to add a revision tag to the test model so I can compare and sync it to the production model. However, the button to add the revision tag is disabled. Please note that the model is in 'Deployed Mode'.
Z Score for Safety Stock
Hello, I need to build a formula to calculate safety stock in Anaplan. I have lead time & usage data available. I am inquiring guidance with developing the z score formula. Inputs will be appreciated, thanks!
To display code of Child and parent in a single line item
Hi, Is it possible in Anaplan to display the codes of both Child and parent in a single line item. I have requirement to show the code of both in the same line item. If its Boolean then Any or All summary would work since its text and the list would be at child level I can't apply Formula as a summary so any work around…
Level 2 Sprint 3 - Inventory Ordering Module Formulas Module
Hi, I have created the two boolean value but I am having problem while creating Beginning Inventory. So can anyone please help me with the correct formula and data.
hotw to obtain period of line item
Hello, I'm stuck on a formula that seems obvious to me. I would like to retrieve the time period of a line item : Week : list formated. time period by week : format time period, applies to week => i want to obtain time period for each week. Any idea? thx for your time !
Demand Forecast Detailed Demand Grid UX.
Hi, I am having problem in Level 2 Sprint 2 - DEM03 Demand Forecast Module in creating a saved view as I am not getting what they are saying to do. So can anyone please help me with the correct formula and data.
12.4.1 Activity: Filter Dialog Box does not show "Ok" to be able to apply the filter
When creating a filter by applying Filter from system module, I am unable to apply the filter as the dialogue box is not showing "Ok".
Level 2 Sprint 2 - DEM03 Demand Forecast Module
Hi, I am having problem in Level 2 Sprint 2 - DEM03 Demand Forecast Module as I am not getting proper data so it's a request can anyone help me with changes as Override Forecast should have value as 62 but I am getting it as 60 and I have also attached the blueprint view. So can anyone please help me with the correct…
FY Values replicating QTD Values
Hi Anaplan experts, Maybe you can help me with my issue? I am building a module that requires to show the current quarter (CQ) as a YTD value without summing up as FY. It means that if selection is Q1 or Q2 or so forth, FY value should be whichever the month or forecast month selected. Sample ss below: Hope you can help…
Reverse mapping
Hi all I have a source module with dimension list A and an output module with list B. To bridge this, I have a simple third module where the end-user can input the mapping between A & B. This works perfectly for a standard LOOKUP formula. I was wondering if there's an easy way to reverse the mapping? I basically want…
Need to remove duplicated text values from a text Line Item
Hi Members, I have an requirement of identifying unique values of customer in each department. Please see below module which is have a dimension of departments list with three list items(D1,D,2,D3) and a line item(Customer Names) which is having concatenated names of all customers in each department with delimiter as ",".…
Level 1 Model Building exam Activity 6
I dont seem to understand what am i doing wrong in this Please HELP!!
Need to break down Module into Multiple column Flat List
I need some help breaking down data that has been inserted into Anaplan via the excel add in, so that each component in the existing module can be listed as individual line items as in a data list. The attached photo lays out the dimensions I need, but I'd like to see it in a form that has the Cost center, Ledger code,…
Only want user to put in one value
Here's the situation: I have a module with two Boolean line items that should act as the inverse of each other. As an end user, I should not be able to click both boxes. Screenshot below Basically, If the user picks the home team to win they should not be able to choose the Away Team to Win. I thought IF…
Help - Suggestions for Cash Flow Forecast of Payroll Expenses
Hi Community, Hoping to get some ideation from headcount / workforce planning pros out there. Assuming you already have a typical P&L (accrual) forecast for all major Payroll costs: Gross Payroll, Taxes, Benefits, Commissions, Bonus, etc. that you trust to be accurate - does anyone have an opinion on some typical ways to…
Revision Tags
Hi, I have a model with some revision tags. If I copy that model, then how does anaplan decide which revision tag to show in the new and old models? Sometimes it shows the latest Revision Tag and sometimes it creates a new revision tag with the name 'Copy Model'. Thanks.
Workforce Planning - Cash Forecast for Payroll Expenses
Hi Community, Hoping to get some ideation from headcount / workforce planning pros out there. Assuming you already have a typical P&L (accrual) forecast for all major Payroll costs: Gross Payroll, Taxes, Benefits, Commissions, Bonus, etc. that you trust to be accurate - does anyone have an opinion on some typical ways to…
The Life-Changing Magic of Tidying Up Your Anaplan Model
Marie Kondo's "The Life-Changing Magic of Tidying Up" seems to be popping up everywhere these days with her book and Netflix show. I decided to take the principles of her KonMari Method and see how we can apply them to how we build Anaplan Models. The KonMari.com website explains the method: The KonMari Method™…
How to use FINDITEM for a concatenated string
Hi all, I'm a new Anaplan user and have a question regarding the FINDITEM function. I have currently have two numbered lists (1. Account List & 2. Raw Data List) and I would like to use the FINDITEM function in the Raw Data List to match the account ID in the Account List. However, the account ID in the Raw Data list is…
nested Sum if
Hi, I need to get total of selected roles occurrence which can fall in three different categories. For example, among all the users , I need to count how many users have role of ADM, and then if they had the same role 3 months ago also- If yes it will be counted in No change list ( Category 1) and if their role is changed,…

Modeling

Discussion List