Modeling

Planning our Modellers Forum 2022 vision!
Good morning all! So just to keep you up to speed with what is happening in the world of the UKI Modellers Forum...this morning @Paul , @ChanD and I are having a planning session to chart an exciting roadmap for the year ahead. Expect to hear from us with some future dates...and hopefully...some in person offerings at our…
NEXT or Previous cell values without Time dimension
Hi All, Is there any function in Anaplan, which can be used to get the next cell value from first line item in a new line item. or 2nd scenario is to ignore the prior cell values, For example: IF SL1(List item) ignore first 1 cell, for SL2 ignore first 2 cells,SL3 ignore first 3 cells ....and so on. I have done this using…
Lookup and use case
Hi, I am new on using Anaplan. I was looking for use of lookup between source, mapping table and target. I read below statement but could not understand properly. "If your mapping table contains the Target List and maps to a Source list-formatted line item or list-formatted property, then use LOOKUP in your formula." Does…
Level 1 Model Building Exam - Activity 7
I am trying to build out the UX but my data is different in some spots than what is shown in the example. Not sure what to do
Center of Excellence Series - Master Planning
The flavour for this year is not just about recovery but building strength in your capabilities to achieve the growth with scale you planned for, last year was unexpected, we all had big plans that might not have come to fruition, as many of our capabilities were tested. I’ve set myself the challenge this year to help the…
Zero Suppression
Hi, Is there an option to suppress zeroes in a module so all the cells that have 0 or blank as values can be hidden? Thanks Megha
Anaplan model builder level 1 exam activity 2
Hi, I am trying to update REV02 volume inputs from DATA02 SKU volume module using a formula. when I type the formula ‘DATA02 SKU Volumes’.Volume , it returns the error message that: invalid formula for REV02 Volume inputs’. Volume. Automatic sum of DATA02 SKU volumes’.volume over P3 SKU hierarchy is not possible as P3 SKU…
Module
Hi, I am getting Lesson 6 in the level1. Even though I followed all the instructions, my result looks different than in the example. Where did I go wrong? Please help me? Thanks! Mark My screenshots: Example's screenshot :
Department as a % of Total Revenue
Hi everyone, I am currently trying to develop a model that references two different regions within a list (that is production data). Let's say we have 2 line items: New England Revenue Total Company Revenue I want a ratio where I can reference our P&L (300ish line items) and say P&L Revenue [Select: List.New England] / P&L…
Data type mismatch: format other than LIST or DATE being referenced as a relation
When I am trying to enter the formula in REP02 Size Margin Report revenue i am getting an error like this ... (Data type mismatch: format other than LIST or DATE being referenced as a relation)
Movingsum over if statement based on isactualversion()
Hi all! In our model we do not get the wished results from a moving sum. I want to preform a movingsum over a line item which is constructed with an if statement in a model with versions. This is my line item if statement: Where isactualversion is iscactualversion() and is thus dependent on the version. Then we have a line…
About textlist Formula
Hi I want to Textlist function. I want to get Customers by Product List. But I don't know how to use it. ListLineitemProductCustomerConbinationTextListP1C1☑C1,C2　C2☑C1,C2　C3 P2C1☑C1,C3　C2 C3☑ Do you have any idea?
Information regarding the Module is used in any dashboard in the New UX
When we all had classic dashboards only, it was easy to check which module is used in which dashboard by going to the "Used in dashboard" column. However, as most of us are using new UX now, the column "Used in dashboard" has become futile. Also, we don't have information whether any particular module is being published in…
modules width adjustment
The module name will be cut off, so please be able to adjust the width of the column.
Level 1 Model Building Exam Model Building Activity 5 correct sequence
Level 1 Exam question 7 (should the answer be rounded?)
Hi, In response to question 7: What was the total expense for the FY21 executive bonuses in the Americas? the total equals XX.999999999996 do I have to round up? Thank you
Can I use the TimeSum with SELECT
Hello Could you help me with the following case please. I have a formula that is using SELECT but in addition to that I need to add a sum controlled by months with some members that I have already created but when using the timesum it generates an error because it conflicts with the SELECT. How could I solve it? The…
Spring refresh — Anaplan edition
As you consider the areas in need of a spring refresh in your home or office, it is also a great time to do the same for your Anaplan models. The most difficult part about cleaning is figuring out where to start and selecting the tools and equipment needed to get to the finish line. Let’s break it down into three…
Using Delete from List using selection for partial deletion of data for current Month only!!
Dear Community, Needed to check whether is it possible to delete Monthly data using Delete from List using selection for that particular current month. For example if we have data from Jan 2022 to Apr 2022 but we need to delete only the data for month of Apr 2022. How can this action be modified since we can currently…
Copy Across and Down on right click of an inputable cell
Currently option for an inputable cell when right click are copy, hide, breakback, sort etc. It would be nice to have the option of Copy Across and Down in dashboards. It is already available on the edit option of the module.
Model Optimising and Housekeeping
I'd like to have new features in Anaplan where it will check your whole model and return the following: * Module/Lists which are not references in actions/dashboards and therefore can be removed without impact * Line items which are duplicated in other modules and are using the same dimensions (therefore duplicated can be…
History on Formula Changes
Similar to Cell or Module history, there should be an option to get on demand history on formula changes. An option in blueprint mode to select any line item formula and get history option should be added. This will be helpful to track formula change in multiple model builder environments.
Include Formula Change Detail in Model History
Currently the model history process only captures that a line item was edited but it doesn't specify if it was a formula change, applies to, etc... and it doesn't include what the formula is/was. This came up recently in trying to research what had happened with a formula that had previously been updated and it's otherwise…
Allow for 'Invalid' formulas during model changes
When model building often we get requirements that require changing the dimensions of a line item / changing hierarchy levels etc. Basically things that will break existing formulas. To make these changes to an existing model I'll laboriously go about copying formulas that will break somewhere else, carefully making a note…
Built in notepad/clipboard
Hi Anaplanners, This time i am coming with an idea of having a kind of manageable clipboard/notepad built into the development UI. Performing development work i usually have some additional tools like notepad or excel opened on side to able to store formulas or mappings that i want to use in next few mins (example is a…
Get dates in different dimensions module
Hi, I have a requirement to pull the dates in the module, the source and the target has different dimensions. Target module Source module I want the dates basis on the revolver in the target since I can't use sum function on the dates to pull it any workaround for this use case.
User Selected YTD Time Filter
Hi everyone, Currently have a developed user-selected time filter we use on all of our UX Pages. Driving module: Page/Board Filter: We just implemented the YTD summary yesterday and now I am struggling to get some sort of filter in place where I can check a box and it appears similar to how months, quarters, and years work…
Get a total value on other line item
Hi, Can you help me with the next item. I need get the total value of the line item "%" and put in the line item "Pond". in the line item "Pond" is using a LOOKUP but a cant see any value.
Get Average of two month on same line item when is Budget
Hi , I want just calculate the moving average for the last two months, however once use the following formula IF ISACTUALVERSION() THEN Revenue actual ELSE movingsum(Average Revenue,-2,0, AVERAGE) Then circular reference error shows up. Could guys give me hand on how can solve these issues? I am looking forward to your…
Boolean Check the child list member after checking Parent List members
Hi team, There are four lists L1,L2,L3 and L4 in which L1 is parent of L2, L2 is parent of L3 and L3 is parent of L4. I have a requirement in which I want to mark true all the descendent members if I am marking upper level as true of the list. eg. If L1 have A,B,C members and I am marking A as true then the descendat of A…

Modeling

Discussion List