Modeling

Use of default and mandatory "Organization" list in models
Has anyone used the "Organization" list models? Anaplan automatically creates it in every model which can't be deleted. I've never seen it used. I also don't recall any of the Anaplan courses use it. 1. Has anyone used it? If yes, how did you use it? 2. How is it theoretically supposed to be used? I guess theoretically,…
ACTIVITY 2.4.7.1
Hi Team, I have applied the conditional formatting as well as the formular but i keep getting 0 in my Forcast CF line item. Please asist to point me in the right direction of what I am missing.
Level 1 Model Building - Create SYS08 Employee Details System Module
In the Activities, the following is to be created: Below is the result: Is the result correct? Somehow I am doubting it when I started to import data. Regards Star
Need to breakback the value
Hi, I have a module with 5 products (A,B,C,D,E). all the products have some values with respect to 3 line items (X,Y,Z). Now i wanted to distribute the value of A in to the remaining products(B,C,D,E). with common percentage. Any idea how can i do it? Example here: A B C D E Before X 100 10 10 10 10 After X 0 35 35 35 35…
Suppress 0 or missing where there is no YearTotal aggregation
Hi I have a situation where I need to suppress 0 or missing for Headcount, Note that the Months do not aggregate to Year. The months are in columns. How do I achieve this, so that it look at Jan, feb, mar etc.. Thanks
Model Building Level 1 Model Building Activity 6 8 1
I am missing New York? Did I not input something in correctly. I have everything thing else there. Thank you, Katherine
Number to boolean format help
Hi team, Looking for help- i have a column with number format which shows currency value ( total) which takes FX rates into account as well . e.g $2,000,000 and so on... now i want to use filters which will give me projects having valuation more than 1,00,000 i created a boolean filter and tried to change the format for…
Identify Duplicates
Hi friends, Hoping to get some help with a method to help me finish up a labor calculation module. I'm tasked with allocating costs to contractors differently dependent on if there are multiple contractors from the same "Vendor" and "Area". IF multiple contractors from same Vendor in an Area THEN divide Area cost evenly by…
Update a filter based on picklist
I have a Module 1 with 2 dimensions. List A and List B. I have a line item in the module formatted as numbered List C which the users can select. I have a SYS module for List C. I would like to create a boolean in my SYS module that gets checked for any member of the list that a user selects in module 1
Ability to remove more than 1 user at a time
Anaplan only allows for 1 user to be deleted at a time. Recently, we realized 680 users were loaded into the wrong model, so I had to click "delete user" then mouse over to click "OK" 680 times...I'd like to be able to delete more than 1 user at a time.
2.4.2.2 Check your work
I used 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' formula in Baseline Forecast But in 2.4.2.2 work check FY21 is also filled.How can I fill FY21 in my module
QUICKLY IDENTIFY FILTERS USED IN DASHBOARDS
This has consistently taken me way more time than required. As a solutions architect, i need a quick way to identify which filters are being used in the UX. I am currently in the process of cleaning up 100s of filters built in systems modules and it is taking me additional time (and windows) to reconcile which filters are…
What is the best way to sort the list items
Hi All, In which way we can sort the list items names and suggest me in an optimized way which wont increase the model size. Thanks in advance!! Regards, Mahesh Kumar.
[Part 1] Validating user input in Anaplan: Approaches and challenges
Pros/cons of common approaches Common approaches: Examples Error logic User experience Example 1: Simple error messages Example 2a & 2b: Nested IF statement Example 3: Concatenation of multiple error messages Example 4: Separate errors for each line item Wrap-up of Part 1: Summary of common (sub-optimal) approaches…
How to Find Max for Specific line item
I am trying to create a module with the following line items (dimensioned by products in pages and line items in rows, time does not apply). when a product is select from pages: Max slots - display max value across any month When - display the month that the 'Max' appears Width Factor% - user input Width Interval - display…
Filters on the "Actions" tab
It would be nice to have the ability to sort and filter imports by source/target type.
Error with line item is not recognized
I'm try to find medical cost for employee in EMP02 (Employee Expenses) drives by Role and Department where i have to reference to EMP03 (Employee Driver by Role) and SYS08 Employee details. In my formula I didn't query direct EMP03 source module into target module EMP02 is because in EMP02 I don't have Department and Role…
Median Calculation on Multiple Dimensions
Hello - has any one ever successfully been able to calculate the median off of multiple dimensions? I have a list of customer spend data at the customer level and would like to calculate the median by certain attributes of those customers. For example, I have 10 customers all who belong to different countries, and…
How to return the month/time period of other line itme
Hello, I have a module with two line items. This module has product list on pages and line items on rows. 'Max Slots' has a formula that returns the MAX value of a given product from another module. For the other line item 'when' I am trying to return the month or time period that the MAX value takes place. I am trying…
Summary in UX Page
Hi everyone, I have a module which is dimensioned by 'L3' List. It hold amount data. I want to filter l3 list by Region. So, I have added a region filter and published as a 2nd grid in the same Page. But, in the Summary for the 2nd grid, is there any chance that I will get only sum of the list items that are filtered out.…
Major UX Page Release! VARIANCE ANALYSIS...directly in UX page!
Yes! You can now do ad-hoc variance analysis! I'm about to jump into this right now and test it out - this is a huge addition to the reporting and ad-hoc functionality. Take a look below to hear directly from the product team and check it out. Please comment if you like this - I am really excited about the options this…
Formula error while pulling data from one module to another
Hello, My goal is to get the 'total volume' of product being used for certain year by different cities. Below are the two data set which have been successfully mapped into Anaplan I want to pull data from DATA02 into REV02 to achieve my goal. SOURCE DATA02- (data SKU Volumes) TARGET: REV02- (data Volume Inputs) I tried…
EMP03 Employee Drivers by Role
Hi, I created the module and successfully imported data for EMP03. In the certification, it requires us to update line items to reference the driver in EMP03 in the EMP02. I keep getting this error shown below. Invalid formula for 'EMP02 Employee Expenses'.Bonus: Automatic sum of 'EMP03 Employee Drivers by Role'.Bonus %…
Last Workday of the month
How would I create a Boolean line item that would select the last work day of the month? Thanks
Level 1 Model Building SYS08 Employee Details Import Issue
We are asked to import Emloyees.csv into SYS08 Employee Details and I am unable to get the names in the list to match on the names in the employees list that I already have in. I checked and I have the data type as "Text" listed within the SYS08 module, and the .csv has the data in that column listed as "General". I also…
Parent to Child Mapping
Hi, Is there a way to map a selection made at the parent level to all the children of the parent? Product Hierarchy: L1 Program, L2 SKU My final output report is at the L2 SKU level. The users take multiple snapshots of this report during planning cycle. At the end of the cycle they want to select a final snapshot for that…
Advise on building methodology
Hi, Im trying to build out in Anaplan a way to take all the totals of the first day of each month and then divide it by the totals of the whole month. This will give me a ratio that is needed to multiply by each dayified first day of the month. Thank you
Level1 Training 13.6.5
Hi. I am currently working on building the custom view in activity 13.6.5, however I do not understand how to do a time filtering. I want to select only forecast period data (from Jan 20). I think I should use the 'filter' icon, but cannot build the rule. Thank you in advance!
3.5.4.2 Create Distribution Center Capacity Module
I have completed the below task and added the formulas however, i am not sure about the numbers for the "Total Beginning Inventory" it seems that i have negative numbers as a result the Percentage Full numbers is not right: Thus, i had to check again the formulas in INV01 Inventory Ordering and the SYS08: Could you please…
LAG() Rent Increases without Time Scale
Hello, New Model Builder here! I'm working to enhance an older model that uses a hierarchical list as a Custom Time Scale (CTS Months). The list is used in lieu of a time scale for most modules, however one of the enhancements involves applying market rent increases to the next 'time period'. i.e. a 5% market rent increase…

Modeling

Discussion List