Modeling

Feb releases and...March sneak peek!
Make five minutes in your day and check out the latest release from Feb - with a sneaky look ahead to what's coming! February was a great month with a few really neat enhancements for the UX - I'm particularly liking the enhanced show/hide on UX pages and absolutely loving the ability in the model to see which UX pages are…
Convert Line Items to Time Periods
Our Finance team requested we try to recreate this view in Anaplan for them to make their plans. We are struggling with how to show both the detailed info (vendor, department, country) and the time periods (Jan 22, Feb 22 etc) as single rows in the same table. Our best workaround so far is to include the time periods as…
Display Name not showing properly
I am working on the Level 1 Model Building and cannot get the display name to show in place of the numbered list for E2 Employees#. I cannot figure out where I am going wrong. Thank you for any help provided.
Chrome default setting for Google G Suite Gmail to use with email link or MailTo
If you click on an email link or MailTo link and your Gmail doesn't open up in another tab, make sure that the protocol handlers in the Chrome browser is set correctly. This is what your setting should look like: If your email is not set to default to Gmail, make sure the "Sites can ask to handle protocols" boolean is…
How to extract data from a Line Item that has a Users dimension
hello!! Is there a way to extract data from a Line item that has a user dimension? The Line Item you want to extract does not have a Users dimension.
Formula to YEARVALUE with Actual months
Hi Guys!! Could you please help me with a topic? I have a module, where I need to calculate the average of my NET SALES for 2022, and that every month has the same value. I applied the YEARVALUE/12 formula and it works for Forecast months. However, for the current month, Anaplan brings me the Actual value and divides it by…
not a recognized line item
We are repeatedly getting the not recognized line item error when building out simple formulas sing line items all contained within the same module. In the screenshot below A-3 references A-1 + A-2 and all are clearly line items, this is happening when selecting the lines items with the formula editor and typing out the…
We'd like your feedback on the App Hub
Hi all, We are currently looking for Anaplan customers to participate in 60 minute research sessions.Sessions will take place remotely from March 2nd to March 11th. Participants will receive an e-gift card as a thank you for their time, if their company policies allow them to receive these. For this session, we will be…
Filter on Drilldown to only see items with data <> 0
Hello, I would like to ask if there's a way to make the drilldowns in Anaplan to only show items with data on them <> 0, or isnotblank? Currently, I need to scroll down a lot to locate to the account that has the relevant data. Thank you, Jonathan
Level 2 2.3.9.2 OFFSET formula
Hi i wrote this formula.It has taken without any errors but showing zeroes This is my formula IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 Can u provide correct formula
Change The Units of Line Items
In the UX there is no good option for my client to display a chart with units in billions. The options are as follows: * Divide our final output line item by 10^9. They don’t want to display it as 3dp which is the required level of detail in other columns. * Divide our final output line item by 10^3 or 10^6. The…
Product list formula
Hi - P2 Product list has parent. Why formula is not pulling product family here?
4.8.2 Activity: Import Data into E2 Employees# List NUX
In the NUX everytime I try to import the employee list it doesn't display the name. I am correctly importing but it continues to show the employee names as numbers. Please advise
L1 MB ExaM - Activity 3 - Import Data from Role.csv
I am getting the Invalid Parent error when uploading the Role.csv file to the new list created E3 Role. I understood the parent for the list would be E2 Employees. Any assistance greatly appreciated.
Anaplan History Tracking
Hi, While analyzing history for an Anaplan Model, I came across some inconsistencies. The history seemed to be different when I exported the history for a particular cell as compared to the entire model history. e.g. Consider the below screenshots [You can see ID: 2125693 is showing twice] [The above screenshot is also…
Set Anaplan Import Source via URL
Currently, when creating an Anaplan to Anaplan data import, the process of setting the source is somewhat tedious - it requires specifying the workspace, then the model, then the source type, then finally the actual source. However, with the recently released feature that an Anaplan Model URL specifies an active…
Enhance "Delete from List Using Selection" by accepting filters in combination with Users list
As a model builder, I would like to have the possibility to create an action with the option "Delete from List Using Selection" by using booleans line-items in combination with the Users List additional the List where it is needed to delete the elements. Currently, when trying to build an action "Delete from List Using…
1.3.10.4 Check Your Work
Hello everybody I need your help please, I have a parent issue with my output I must have this : but actually i m having this : the probleme is the parent, actually, i verified the parent in general list and it's ok, G2 country is the parent of G3 location, like you can see: when i import the saved view for G3 location i…
importing into a list - duplicate item error
Hi All, I have a masterdata module with products which have an attribute of size. I have a list of all possible sizes. I have imported into the size list from the masterdata a module to ensure that if a different size is added, that my size list gets updated. All good so far - however when I run the import I get an error…
PL Dashboard - Calculations in both Rows and Columns
Hi, I need to create a PL report/dash board where there are calculations in both rows and columns as in the attached screen. How can I achieve this. I have selections for Period, Year, Products and Region. Based on the period and Year selected, the data should show current YTD, prior YTD and % Change. These are part of…
How can I create an APP - Level 2 Sprint 2
Hi, I am in the middle of Sprint 2 of Level 2 MB, but I cannot see any link to create app on my app page. Do I have to ask for permission or this is what we can get in free trail log accounts for training. Thanks
How to get all periods totals with tiem dimenson in to a target module without time dimeson.
Hi All, I have asituation where I need to pul previous 4 years totals into another module which do not have time as dimenson. How can I achive this. My module screen shots are as below. Blueprint view of same The data needs to be pulled into blueprint view of same is Thanks for your help. Balrama Krishna
2.3.10 Create DEM03 Demand Forecast Module
I think I have successfully completed the section but I feel like there is something missing. Other than the Growth Rate %, I have no other values in the other line items. Am I missing something or are all other line itms intentionally blank/zeros? AM I missing the formulas?
Ability to add a property column before dimensionalized columns
The customer request is added flexibility to add initial columns in grids that are not dimensionalized by the columns in the grid. This is mostly for improved experience/planning for end users, but also can help refine modules. The first image shows how we would like to display the property in a separate column: The second…
Production plan
Hello ! I’m actually building a supply chain model in order to train after getting the certified model builder. However, I can’t figure out how to build a module that will provide me a production plan. I explain myself. I’m working on vegetables that are demand all along the year but that you can only harvest during a…
formula
How to get average prices from monthly data into Non months.
New Modeling Experience updates - February 2022
Hi everyone, We're pleased to offer some great new capabilities in the New Modeling Experience - check them out here: https://community.anaplan.com/t5/Feature-Updates/Explore-the-latest-updates-to-the-New-Modeling-Experience/ba-p/132843 Thanks
Sprint 3 - Activity Create Inventory Ordering / 3.3.5.3 Check Your Work
Dear Community, 3.3.5. Activity: Create Inventory Ordering/3.3.5.3 Check Your Work Please help with this activity... values are not matching, need solutions/formula hints to match the same.
Flagging different values at children for same parent
I am looking for an efficient solution for the following: * I have a module that is multiple levels, compound list - think of it as L1 and L2 * A line item within that list is an ID for each L2 * I would like to flag all L1 members that have multiple IDs for their respective children (L2). * In the screenshot, there are…
Dependent Dropdown by using filter
Hi, I want to use Dependent Dropdown list. I want to use Boolean Lineitem as "Filter Filter_Product based on data in " setting. Now I can filter by only 1 item. If we can this system, I can filter by 2 or more than items. In Anaplan, Can we achieve this?

Modeling

Discussion List