Model Builder

L2 Sprint 3 - 3.3.6
Can anybody please help me with why my data is showing 0 instead of 16388 in Confirmed Purchase Order Receipt (week 3) after following the instructions in the screenshot? I have applied the following formulae: PO Submitted: IF Submit Purchase Order Request? THEN 1 ELSE 0 Confirmed PO Delivery: POST(PO Submitted, Final…
Module Lines System Generated 'Created by' and 'Modified by' Detail
All module lines should include system generated "Created By" and "Modified By" detail for audit trail, compliance, and support reference. It is not always clear as to whom created or modified a line in a module. If a consultant or contractor is making changes to lines, the only way to find that detail is by combing…
Allocate a summary level data input into other
Hello, In one module, I want users to enter one growth number for a country. I then want that growth number to be applied to every single product in that country (in another module). There are thousands of products in the country, so I don't really want to have to enter the same growth number multiple times. However, I…
Add back the 'Used in Dashboards' reference for Modules (with NUX)
With the NUX in place and being the standard for dashboarding, it would be good to have the ‘Used in Dashboard’ reference working again within the Model. This would be good for the transparency/auditibility of the model, for all users. With the Classic UX, it was easy to see when a Module was used in any of the Dashboards.…
MailTo Limits in Firefox vs. Chrome
We are using the MAILTO function to generate an email to a BCC-ed list of users of action required in the model. The list of BCC recipients is lengthy (>100 email addresses), and the MAILTO function appears to work in Firefox, but not Chrome (OS = Windows, email client = Outlook). Has anyone run into similar limits? Are…
How can I restrict users selection of months
How can I restrict month selection drom a dropdown? For example I would like to set a dashboard where end users can only select pre-defined months i.e. Jan 23 to Mar 23. Is there a way I can easily change this by adding (locking/unlocking option) additional months if needed. Thanks!
L3 User Story 1.4 Steps
I am unclear about the process for creating the modules for User Story(US) 1.4. On the surface this seems to be the exact process for the previous US where we combined Accounts and Product, except now we're combining Accounts and Territories. Where I'm confused is how we process the G3T Territory data. Since a territory…
Setting a Date formatted line item to Blank
I am trying the following. Not sure if the issue is that the Date format items can´t be blank or something on my formula
Model Builders and Solution Architects: We want to connect with you!
Are you a Model Builder or a Solution Architect who works to create a set of rules and validations for data in Anaplan? If so, we want to speak with you! We invite you to join us for a 60-minute remote research interview, during which you'll be asked to weigh in on a new way of creating rules and validations in Anaplan.…
Asana is looking for a Product Owner Planning Systems
Come work for a great Enterprise Technology team, implement and support FP&A, Workforce and Territory & Quota planning. For more information about the role go to:
How to fill a line item recursively
Hi! I have one module where one of the line items is my inventory amount and on the columns I have a list where I put diferent fiscal years (note that I cannot use the formula PREVIOUS() because this module is not connected with Time, and I can't connect it either). So my list is composed by: FY22, FY23, FY24, FY25, FY26,…
How to convert Month Line item in text format to Month Format
Hi All I have two month line items in text format as shown in picture and want to convert to Month formatted line item. What steps should I take so that I convert it into Month formatted line item. Thanks in advance
Extending a week
Hi All, Is it possible to add a week in the model calender for a new year without adding a new year in the time settings. TIA.
How to differentiate when a line item is input and calc on the same module
Hello! I'm trying to build a module where one of my line items is an input on one hierarchy but a calc on another level of the hierarchy, but I'm not sure if this is possible to build in anaplan, let's have an example: My Hierarchy is: Season Winter Summer On the module I have the following line items: Account Receivables…
Shortcuts for Anaplan in new user experience
Having in mind recent improvements in the way that anaplan is using new formula formatting and "inteli-sensne" like interface when using bottom formula bar, its so much wast that there is so few shortcuts inside anaplan. Some of them are not working at all with new experience (Ctrl+>, Ctrl+< - working only with anaplan…
Help me with this issue.
I have this two modules: AND I want to pull the territory ref ID sys/fil07 to the inp/ter01 so it would only show territories available for that employee, i have tried to do loots of formulas but they dont seem to pull it correctly, not sure if because inp/ter01 is made with subsets its messing it up or something is wrong,…
Get monthly value for base year selected
Hi, I have a module (dimesioned monthly) in which I need the base year values. The user selects the base year. I have created a seperate module in which the user can select the base year. However, when I am using the base year in the lookup, I am getting the full year value, instead of monthly value. Example: if user…
Lost all modules and apps
Hello to you all, I'm preparing to take the Level 1 exam. I finished all the exercices (modules and apps). I dont know if it's due to the maintenance schedueled the 25th or something else but I lost all my workspace last Sunday. I have mailed Anaplan to see if I can get my workspace back but I'm afraid i wont have enough…
Model Builders: Take our quick poll!
“Before you became a model builder, was your previous career path in IT or an industry focussed team (e.g. finance)?” Submit your answer here: https://www.surveymonkey.co.uk/r/ZPKT55Y
Selective Access and Tabular Multiple Column Exports
I have defined an export using the Tabular Multiple Column layout, filtering using a Boolean from a separate module. The module being exported uses a list with Selective Access. When I try to limit my access and run the export, to test how an end user would interact with the export, the model exports rows for ALL members…
Sum based on Parent in Hierarchical List
Hi, I have a hierarchy of lists, L1>L2>L3. My module is dimentioned by L3 and has two line items, Input value and Input %. Input Value is entered by user. Input % = Input Value/Sum of Input Values for all list items of L3 under a L2 list item. How can I calculate this sum, as it is the sum of all items in L3 under L2 a…
ALM - Calculate Model Size
It would greatly improve the Anaplan ALM experience if Anaplan was able to calculate the impact to the model prior to pushing a model sync. "Completing this sync would cause your workspace to exceed its size limit" It is pretty inefficient that model builders are forced to wait to find if completing a sync would exceed a…
L3 sprint 2 2.3.1 QUO01 Territory Account Validation
Hi everyone, I am a bit confused and have been stuck for a while, how to approach the line :" Assigned>1?: Is the account assigned to more than one territory? " also, what is the purpose of "cf_account" line? which modules should I reference? any ideas? Thank you!
How to know a parent is selected
Greetings, We have a model where a Employee have territories assigned, each territory have accounts assigned. At the moment if we edit the end date of a territory the end date of the accounts stay the same. So i want to make a formula where if we mark the territory for edition , a boolean on the accounts gets active as…
Level 2 Sprint 3 3.4.4 Activity: Create Stock Exceptions Review UX Page - SKU Missing Only Products
Hi, I am not able to allow SKUs in the Stock Exception Review to show up, as shown in the screenshots attached. Instead of SKUs showing up, I could only allow P1 Product Family: chocolates, Sours, Taffy, Fudge to show up. What I did in My Page was that I selected INV02 Country Summary Module into the grid view. I am not…
Variance module using item subsets
Good morning team. I have a labour model that I am looking to add a variance module to and need some assistance understanding my options. As we have a number of different versions, using native versions for the variance is inefficient and will cause the model to grow much larger than required. The planning module currently…
LIS INDENTION
Hi Team, Is there a way to fix the LIS Indention of those identified as Parents, other than unticking the parent button in the source module, please? Please see screenshot for the sample indention being mentioned. Appreciate your assistance. Thank you, Elaine
Build Dynamic YTD/YTG with Non-Native Time
Hey Builders, I'm working on a project which requests a report that requires non-native time due to needing YTD/YTG at the end of each year to track variance on last year's YTD vs current year's YTD. The period to reference in the YTD is to dynamically change as the Current Period is updated within every year, regardless…
Level 3 sprint 1 8.4
Hi Everyone, I am trying to validate my data for the "Final sales target" after applying the "Factor". However, looks like my Factor is off. I have confirmed that "previous year actual revenue" and" initial account sales targets" are correct. so not sure where it is off.... Mine: Anaplan: needed formula concept : Thanks…
Summing values for a year
Hi, I have a line item which is equal to (Monthly income)/(yearly income). How can I reference the yearly income (or calculate it), I have the monthly income as input. Thanks

Model Builder

Discussion List