-
Max Value for a Line Item on a yearly basis
I am trying to find the max value in a different line item for any given year, all in the same module. time is in months so my start month would be january and end month would be december. so for 2023 I want the max item, for 2024 I want the max item, and so on and so forth.
-
Better Formula Editor for Anaplan; A Chrome/Firefox/Edge Extension
Hello all! A while back I made a Google Chrome and Firefox extension that enhances Anaplan formula editing by using the Monaco editor (currently 700 users). This is the editor used by Anaplan's new modelling experience. My extension works with this new experience adding enhancements over and above what Anaplan have done.…
-
Optimizer: Dynamic Time Setup
This video will demonstrate how to setup a dynamic time list for use with the Optimizer. Download the attachment for instructions on how to setup Dynamic Time. https://www.youtube.com/watch?v=hD7Wt4wcxwM
-
Optimizer: Exercise Walkthrough
This video is a walkthrough of an Optimizer exercise. Download the attachment for a printable version of the exercise instructions. https://www.youtube.com/watch?v=rwwXAB9Rbp4
-
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…