Modeling

Lookup if Code in one Module exists in another Module
I have two staging modules: 1) Account Master, and 2) Account Ledger What I am looking to do is populate accounts from the the account master where the accounts exist in the ledger. I don't want to populate ALL the item in the account ledger since there are items which are no longer used, or that are "helper" items for JD…
Model search engine to make multiple search by exact name using apostrophe (')
This idea is the following conclusion from my previous idea. As a model builder I want to be able to copy a cell of the module blueprint "Referenced by" and paste this info to Model Search. I expect model search will find all of the modules referenced by the source module. So I could select quickly the necessary one and…
TR02 Account Details Final Account Sales mismatch check on the build
Hi guys i don't know where did I do wrong its mismatch on the 2nd pic below on the check build anyone give me some tips where did I do wrong thank you
Quarterly Lookup
Hi, I'm trying to look up the last day of the Quarter for a LI, and then also find the average of a Quarter. How would I go about doing so? Thank you
Flag list member based on whether it's referenced on a property of other list members
Hi, I'm sure I'm having a blond moment. What's the easiest way to achieve the equivalent of this Excel formula/situation (Column F), in Anaplan ? Thanks!
How do I move one value to the next month?
I have a calculation currently in the "Usage Base Forecast" line item. I want it so that if a user checks off the "Use Previous Month Final Forecast", it moves the final forecast from last month to next month. For example, if the boolean is checked off for July, it will take the "Usage Final Base Forecast" and move it to…
Any alternative for the TEXTLIST() function?
Hi all, The use of the TEXTLIST() is not a best practice. However, as I go through the Anapedia, Planual and forum threads I haven't seen the alternative for that. There are some forum threads that provide ANY, FIRSTNONBLACK, LASTNONBLACK as alternatives for the TEXTLIST[], which is aggregation function. But I need…
Display year based on range of numbers
Hello, I have a module that contains a bunch of servers, and for each server there is an asset tag. The asset tags are in sequential order. I was wondering if it was possible to display the year for each server based on a range of the asset tags. For example, for a given sever, I would like it to display FY17 if its asset…
Syncronize card template context selectors for Microsoft 365 extension
Summary (See suggestion* for detail) - Improve user experience with user driven context selection for cards in template library, rather than going into the backend and updating each saved card for the required context. Context - The release of the extension - Anaplan for Microsoft 365 allows users to import from cards in…
Not able to sync the tables (main table and the subsidiary view)
Hello All, I have an issue where in there is table 1 with below structure: List (category list)Line item1 Line item 2DifferenceA11257A2410-6B11020-10B2633Total3238-6 And there is a table 2, which is a Subsidiary view created based on a source module that is used bring the count/ values in table 1. The purpose of table 2 is…
Level 3 4.6.3 SYS14 Module
Hello So I was able to get the desired outcome but the formulas used are not as per the PLANUAL. I have created two system modules SYS04 (dimensioned by P2 Product) and SYS02 (dimensioned by A1 Accounts). But when I try to use the formula SYS02 AccountDetails.Code & SYS04 ProductDetails.Code to use(Line item: CODE) , I get…
Level 1 Activity 5 _ Employee expense Lookup Formulas resulting in zeros
I am getting zeros for my lookup formulas in Activity 5 for employee expenses. EMP03 Employee Drivers by Role seems right. Attached SYS08 Employee Details seems right _ Roles, Departments. Attached My lookup reference formula seems right - referencing the EMP03 file and mapping to the associates via Lookup in the Sys08…
Automated Email Trigger
Anaplanners, Is it possible to trigger automated mails/notifications from Anaplan to users based on project stages. So if a particular Project X has moved from stage 1 to stage 2, there should be a mail that needs to be sent out to the manager managing the project X. Is the above possible, currently I have followed a…
Lv.2 Sprint1 1.5.2
Could you gime me an idea? I don't know why there is no data...
Bar graph is showing data for June-22 in all months. How can I fix this?
I have a bar graph on my UX page showing headcount per month, but the chart shows the same data for all months when I've only loaded data for June 2022. I would like to see all other months show 0 until I load additional data for these months. Are there steps to fix this? The data I've loaded does have a month identifier…
How can I add a drop down list that allows end user to filter data in grid?
I have a headcount dashboard with grid that shows employee name, team, region, level, etc. The end user will validate the information in the dashboard so I want to give them the option to filter different columns to search for specific fields (employee name, team, region, level, etc.). I have created a card that links to a…
Can I add drop down list (with data from a list) to cells that are loaded with data?
Can I add drop down list (with data from a list) to cells that are loaded with data? I've added a validate button, but now I'm trying to create a functionality that allows managers to make changes to data if the loaded data is incorrect. I'm having trouble including both a drop down list and prepopulated data in the same…
Users List as a basic Dimension
Hello, I ran to the several issues when I needed to calculate some values on the Top Users level. * Users list itself doesn't have Top Level and there isn't an option to add it. Therefore you can't get Total number for given line item that applies to Users List. I was trying to do some workarounds (creation of Dummy Users…
Anaplan Live! Recap for model builders and technical teams
Now that a couple of months have passed since Anaplan Live! in San Jose, I have finally had a chance to reflect and think back on some of my favorite topics that were covered in the Platform track. I enjoyed the new and rekindled connections I made at the event, but if you're anything like me, you didn't have time to…
How to reference a users list in a module
Hello, I want to reference the email address line item from the 'USERS' list to a new system module. Is there a way to reference it?
Converting Serial Number to Data Format
Hi, How can i convert serial number to date format in Anaplan? Thanks in advance for helping. Tom
Problem with replacing SELECT with LOOKUP
Hi everyone, I am replacing SELECT functions with LOOKUP as a part of model optimization (2.02-14 Avoid using SELECT). I did it lots of times and they worked but I am struggling with couple of them. My approach is that I use mapping module to use LOOKUP instead SELECT. I add list formatted line item and select the list…
Invo5 shipping costs
The above image show what has to be done I have attach the data i am getting for shipping cost is wrong I am not able to rectify please help me out what i have done wrong .
Import from Subsidiary View
Does anyone know a workaround to import from a subsidiary view?
MB 1 13 6 4 and 13 6 5
Community, Working through MB 1- on lesson 13 now to set up UX pages. The results of my first attempt at a Volume Chart, followed by Margin Chart result in something not desired. The line graphs follow along the periods then comes the full year values. The full year values make the visualization unusable from an end user…
INV01 Level2
I have attached screenshot ,what booleans I must have checked in INV01 so that my module will be ready for further calaculatons or whatever changes I should made in this module to make it calculation ready.
Level 2 Sprint 3 3.3.7.2 Add DCA to INV01 Inventory Ordering
Almost completed the work Just confused regarding my work plz suggest if I am wrong 1. Should I use "Submit Purchase Order Request" line item as formula in AD02 Inventory Ordering for Overrides "Submit Purchase Order - Write? " OR 2. Should I use line item "Submit Purchase Order - Write? " from AD02 Inventory Ordering…
IF THEN statement with Time Dimension
`Hi Team, I have a module dimensioned by Employee Roster and Time. In it I have a line item 'Train/Predict'. In this line item I want to add a formula such that if it's a past time period then Train and for future time period = predict. I tied using the following formula - IF ITEM(TIME) <= Current Month? THEN Train ELSE…
Classic Dashboard - What does this mean ?
Dear Community Members, I am on MB Lesson 12. I have noticed the phrase "........ on a Classic Dashboard or a UX Page" is mentioned frequently in the lessons. I may have missed it from a previous lesson, but I do not understand what the "Classic Dashboard" refers to. Does this refer to the overall Anaplan Platform…
DYK - Week 13
Did You Know? That Functional Areas are directly linked to the Model Map as far as the coloring or the grouping of the modules in the Model map is concerned. Most of us know that we use DISCO as a principle for segregating the modules or grouping them together for Logical (L) element of PLANS which surely helps in creating…

Modeling

Discussion List