Modeling

SUM is making the formula invalid
Trying to pull the SUM of X list from a module but receiving the below error. Source module is having a list datatype line item i.e. COST CENTRE (though dimensioned with other list) and the target module is dimensioned with the subset of the same list COST CENTRE. When trying to SUM HeadCount based on CostCentre then the…
How to get an attribute to show at all planning levels to use filter
We have three planning levels and want to be able to filter based upon an attribute of one to show all three. L1 - Client L2 - Department L3 - Product The attribute we want to filter by is Territory, which is determined based upon the L2 Department Level. I think that this is a dimensionality issue and there is not a…
Level 2 Conclusion/Sprint 3
Hi All, I am wrapping up the Level 2 training and am stuck on why my data for everything new york is not populating. My guess is that I do not have 'submit purchase order' as a formula and therefore there is no actual shipping occurring in the model other than the ones selected for NY. If someone could please provide some…
Difference between Non-Time Series Functions and Time Series Functions
According to this mini demo, time-functions are divided into two categories: non-time series functions and time series functions. Non-time series functions include: * ADDMONTHS, DATE, DAYS, END, INPERIOD, MONTHTODATE, START, YEARVALUE. etc. Time series functions include: * PREVIOUS, NEXT, POST, LEAD, LAG, SPREAD. etc. I…
September 2021 Release and October Sneak Peek
September 2021 Release and Sneak Peek at October 1. Pasting into Breakback Cells: Within UX, now it’s possible to easily paste values into Breakback enabled cells which are highlighted by blue markers just the way we had it in Classic UX. Note: Hold, Release and Release All features are still not available in UX 2.…
L2 Sprint 2 - 2.3.10 - Create DEM03 Demand Forecast Module
I have inserted a formula successfully but i am not getting any values for other line items. Can anyone please help in this regard.
Style - Summary - With Line above
A relatively simple request. But could we have a summary style option that is the same as Summary 2, but with the above the cell? To me this would be used for subtotals and it just makes more sense that the line be above the number that is considered the Subtotal?
Line Item Subset Filtering
I'm using Line Item Subset to filter line items. This filter would be published in the New UX and the user will be asked to select the respective Line Item and the selected line item would be displayed. How do I approach this build, could someone suggest a tip, I want all line items to be displayed by default and when…
Lookup between two lists formated line items
Hi guys, im trying to do this lookup. I will start by stating the goal i want to achieve: i have 2 lists formated line items in module 1: Product and Partner. In module 2 i have one list formated line item called "quantity". in module 1 i have a line item named "auto" that should be auto filled according to user's…
Interaction of version and non-version modules
I have two modules, the first includes versions as a dimension and the second doesn't. There are 4 versions, Actuals and 3 forecast versions, with one of the forecasts marked as current. If I create a line item in the second module (with no versions) and reference a line item in the first module (with versions), what data…
L2 Sprint 3 INV01 formula for shipping time in weeks
Hi All, I am trying to write formula for shipping time in weeks line item in INV01 I am referencing TRA01 shipping time(weeks) as source in my lookup and SYS08 code as Mapping. and I am seeing that TRA01 is at P2 product list and SYS08 is at P3 sku level. How should I connect these 2 to avoid error. Please guide me in…
Filtering a GRID-NEW UX
Anaplanners, Module A dimensioned by Projects, Time, Attribute List 1 and Line Items. I have projects as row headers (which has to be filtered based on Users and other conditions). I have Time as columns, above that as columns as I have the line items and above that Attribute List 1. So my end table would look large…
Line Items with Version LIS
Hi, I have a P&L with 20 line items currently in a module. This has 2 other dimensions Entity & Division which are Lists. It has native versions as well and monthly time. I'm trying to create a new module which takes some lines from this P&L with different combinations of Entity & Division which I'm comfortable creating…
Is there a formula to get a specific date for the end of the year?
I would like to use Dec of the following year as a lookup (example: this year is 2021, I would like to lookup revenue for Dec 2022). Is there a formula I can use to get the end of the calendar year month for the following year?
Activity 8.5.2 Can't import price bookc
Hi, I tried to import the PriceBook.csv, but when I try to map the data, the mapping tab shows complete different view than it should be. I guess the Modle REV 01 Price Book is correct. Probably something ist wrong with the reference to the list G3 Location oder P2 Products? I need help, because I am stuck at this point.…
Validating/ highlight history (previous value)
Hi All, I am looking one of the use case to validating the history/previous value. Below is the use case: I have two modules (Module1 and Module2). Both are copy of each other. User will input the value in module1 and data will imported in module2 with the help of Import action. So ideally all the data of module1 and…
12.4.1 Activity: Create Saved View for Non Employee Expenses
I have created a saved view and named the view: as Forecast Periods The SYS00 Time Settings module has a line item for only the Forecast period. How to set Forecast Months only Filter? * Filter: Forecast Months only I am unable to set Forecast Months filter. Can anyone help me on this?
NMX - Manage Models?
Before I reach out to Anaplan Support I just want to make sure that if it's only me or anybody else facing it. In New Modelling Experience (NMX) I am not able to see "Manage Models" Option. Misbah
Level 1 Model Building Exam - Activity 5
Hi all, I'm stuck with the calculation of the bonus, car allowance,... by Role for more than 3 hours now. I get an error message referring to the G2 Country hierarchy, but G2 Country is not even in my formula. Is there some link I should break? Thanks in advance for your advice, Valerie
Activity 1.5.2 (My question: How do I rename a new level 1 model?)
I am not asking how to rename the Example model, that was done. I created a new level 1 model and named it but I want to follow the correct format shown in the Activity 1.5.2 which should be L1MB-my name.
L2 S2 2.3.11.2 Create DEM03 Saved View for Global Demand Assumptions UX
Hi All, For 2.3.11.2 Create DEM03 Saved View for Global Demand Assumptions UX Module: DEM03 Demand Forecast Saved View Name: Global Assumptions Grid UX * Add a filter to this module to display Months only. * Use Months as the columns and line items as rows. * Display only Baseline Forecast and Initial Demand Forecast line…
Exam Activity 6
I know I can't get answers, but I feel like everything should be correct in my formulas. However after I entered all of them, they just populated 0's. I've checked the source material it's pulling from and it's all seeming accurate. Could someone help point me in a direction to troubleshoot the lack of data? Thanks!
Setting to ignore elements when imported into a time dimension.
Hello everyone! I constantly face the problem that I described in this topic. The problem is that if, when loading data, you have time in the columns, and the rows have several non-embedded columns (reference for the user, outgoing measurement (and the mapping is done according to an additional LI: code), then at the start…
Activity 3.1.4 Set time dimensions
Hey guys Do we save the settings after completing the steps on setting the time dimensions?
I want to add time as dimension in existing module
I have created module without time as dimension. Now how to add time as dimension in the existing module? Can anyone help me please?
Enable Hot Key Refresh for modules, etc.
Hello, I find myself trying to refresh classic dashboard and backend modules with Alt+R, similar to the UX, and it would be great if we can get this functionality on the backend for module build.
Toggle the Aggregation (e.g. SUM:) part of Formulas Off to Make for Easier Reading!
Hi Anaplan, One of the things customers love about Anaplan is the easy-to-read formulas/ references that are visible through drill down or when modelling. However, the aggregation part of the formula (while important) can sometimes make the formulas look more intimidating than they really are and much harder to read. It…
Publish with Time and non Time Line items
Anaplanners, Quick question. I have two separate modules 1) Module 1..dimesnioned by only Project List with X number of Attributes as line items. 2) Module 2 Dimensioned by Project List and Time and line items. Is there anyways that I can have a single a view, with Project names as row headers and Time along with non time…
Recreating Excel Formula in Anaplpan
Hi, Trying to replicate this same Excel Formula in Anaplan, but leads into a Circular Reference. Please advise on how would do so. The Excel Formula and the Formula we are attempting to us in Anaplan are below. Excel Formula: =IF(AND(AJ31=0,AK31=0),AJ103*AK$71,IF(ISBLANK(AK31),AJ31*AK$71,AK31)) Anaplan Formula: Thank you
Dynamic List Name based on selection/input
Anaplanners, So I have a numbered list, which is used to populate project names by the end user. Projects are created in Anaplan by the end users, they provide name of the project and input various other attributes pertaining to the project. However, I had a doubt on one new request, if the user selects a particular region…

Modeling

Discussion List