Modeling

Order List Action
Hi There id Order List action which is used to sort the list But we can sort if the module has only one dimension Is there any other way we can sort by using order list action if there are multiple dimensions like (2 lists or one list and time) Kindly give the solution Thanks Shirisha.
Copy Line Item
As a user, I want to have the ability to copy a selected line item while in blueprint mode. This functionality would save time and prevent potential user errors/toasts. I will know this is successful when I have the ability to copy an existing line item and type the name in a dialogue box that is brought up after pressing…
Ignore boolean flagged items/periods when using the AVERAGE function
Description: As a model builder, I would like to be able to include an additional parameter in the AVERAGE function which is to be used to exclude flagged items or periods from being included in the calculation of average values. Use Case: There are numerous circumstances where I have been required to exclude certain items…
Time Filter
Need advice best way to set up a Time Filter in my Daily Model that gives me only the Weekdays and not the Weekends. Please Advice. Thank you
What is difference between: ITEM & FINDITEM
EoM
Unable to infer employee-region relation given employees have accounts and accounts belong to region
Hello all, I am building a standard org. hierarchy consisting of employees, accounts and regions with the following rules: 1) Each account can be assigned with only 1 employee. 2) Each account belongs to only 1 region. 3) Each account for one employee is within one region. For some calculation purposes, I need to know, to…
Box and Whiskers Plot using Combination Charts
It would be a wonderful addition to the new UX, if the combination charts were allowed to be used with many different parameters which cater to many statistical methods such as box and whiskers plot which would allow to plot IQR (Inter Quartile Range), MAX and MIN of the entity as per traditional plot of Box and Whiskers.
Add a date stamp
HI All, II need to add a state stamp into a table. My plan is to have a Line item that somehow calculated the current time (equivalent in excel would be NOW()). I then plan to use the Import data to import that date into a static date line item in the same module. Does anyone know how to get Anaplan to show the current…
take a value from another module
I have a module named AAA like this: lowerupperPayout ratetotal invoicestatustranche 105000%$ 8500tranche 25009002.5%$ 8501tranche 390012003.0%$ 8500tranche 4120015003.5%$ 8500 And another module named BBB: QuantityValues $Rate Appliedproduct 148000$ 250?product 2 $ 210?product 3 $ 200?product 4 $ 190?TOTAL $ 850 I want to…
Decreasing the length of your formulas
All too often, when analyzing a model, we see very long, convoluted, and complex formulas. These are commonly nested IF THEN ELSE statements and can be in excess of 5,000 characters. Line item subsets (LISS) can be used to shorten the length of the formula while making the solution more dynamic, scalable, maintainable—and…
Data from one module to another module
Hi 1st Module I have expense list(5) and key figures list(6) with boolean line item (Check) .For each expense will check different key figures Another module Dimensions - Index list , Time and Versions Expense List formatted line item Key figure list formatted line item So when I select particular expense from the drop…
Docusign mapping
Hi , I am trying to integrate docusign integration . I am struggling to map line items in template . I have a below module ,email is email format I want to send a template with line items (first name,last name ,a,b) to "email ids" (3rd line item) .I managed to send the template to email ids but not able to pick the other…
Filter for Module
Hi, Having a hard time setting up Filter in the Module. I have created a Line Item in My Systems Time Setting Module that Boolean checks when a day is a Weekday and not checked when a Weekend. I need to know how to pull this filter into my Module. It is not giving me the option to do so and Im not sure why. Thank you
Sub percentage allocation based on different attributes
Hi I have one module with dimensions of Index list(Numbered list), time,versions I have 4 line items 1st- cost center-list formatted 2nd-Planning-list formatted 3rd-Business Area-list formatted 4th-Percentage-Number formatted(%) so cost center1-Planning Account1-Business Area1-I will enter %(20%) cost center1-Planning…
Form adding L3 Cost Type # list item only to specific C3 Cost Centre # list item
Hi, I currently have a module dimensioned by 2 Numbered lists: * C3 Cost Centre # * L3 Cost Type # I want to present a module on the UX dimensioned by these two lists and a line item for the Amount. The thing is, I want to be able to add more L3 Cost Type # list items from a Form, and that should only be added to a…
Find the position of nth time a character appears in a sting
I want to pull the description details from the History log. I have calculated the number of commas before the Description column which is 3 but I am not able to find the position after the 3rd comma to extract the Description data for multiple rows. Row 1 - ID,Date/Time (UTC),User,Description,Security Change,Previous…
How can I set conditions (IF THEN ELSE) when the first argument of my IF statement is not BOOLEAN
Hi, Would like to know how can I set conditions (IF THEN ELSE) when the first argument of my IF statement is not BOOLEAN formatted. What I'm trying to do is put conditions on my Row's A+/A++...ect to determine what number (6,9,12..ect) they will fall under. I have a pic attached. Please advice. Thank you
Daily Rolling Forecast
Hi, I'm trying to set up in my Time Systems module a Daily Rolling Forecast, but having some trouble making it work. I have attached pics of what I have done. Please advice Thank you
Sum Error - Mismatch
Hi, I am attempting to bring in the sum of one line item from one module to the next and getting the error: Data type mismatch: format other than LIST or DATE being referenced as a relation Here is the formula that is failing: and the referenced module: Thanks!
Publish other actions to new UX
Hi Is there any possibility of creating delete or add row of a number list action(other actions in Anaplan) in New UX ? Thanks Tejaswini
Publishing of the dropdown option
Hi, I have two different hierarchy of lists. Both have n number of hierarchy. List one has display name as Priya and the other list is referred as Priya | Anaplan, Priya | Java. The display name for second list is the combination of first list and course. Here, Priya | Anaplan, Priya | Java have same Priya. As first list…
Parent to Child Lookup/Selection - Part II
Does anyone know if there a best practice around sourcing data where the target module is dimensioned by a parent list and the source is a child list? Target Module: Roles Dimensions: Team Roles, Staging Opportunity Target Line Item: SF User ID Formula: Teams.'Item: SFDC User' Source Module: Teams Dimensions: Staging…
POST n periods later
Can someone explain to me in plain English what the POST n periods later line item is doing in this screenshot? I understand what POST to a later period does, and what POST to an earlier period does, but I don't understand how we are getting 3,000 in the yellow highlighted cell here: Any explanation would be appreciated.…
Getting error while applying lookup
Getting an error that The formula for 'REV05 Price Growth Rates Staging'.Unit Price % is invalid: Unit Price % = 'REV04 Price Growth Rates'.Unit Price%[LOOKUP: 'SYS04 Location Details Module'.Country, LOOKUP: 'SYS06 Product Details'.Product Family] 'REV04 Price Growth Rates'.Unit Price% is not a recognized line item or…
How to search Sort option?
Hello. The new Action "Order List" is added. So I tried to change "old sort option" to "Order List Action". The Refurbishment step is below. Step 1 : Search all modules which are sorted by Line item. Step 2 : Change to Order List Action. But when I do Step 1, Another Sorted Information has appeared like this. I think this…
Time Setting Module
Hi, I want the Line Item "Current Week # of the Month" to show Current week number of the month when Line Item "Reference Date" is selected. Thank you
Query regarding history log
Hi, I needed some clarifications regarding the history log. There are some columns in the log which represents individual lists and there are some lists which are not a part of the log. So my question here is which lists under general lists are part of the log as separate columns and which lists are not.?
Create new List Item from Module
Hi all, I have a hierarchical list of Customers where the bottom two levels are Customer and Branch. I've got a separate hierarchy for products which as its bottom level has SKU. Due to space considerations our Anaplan consultant created a level below Branch for SKU, where items are only created where there is data. We've…
How to input for the first Item while using the Previous Function
Hi, I would like to know how I can input the first number that I need my Previous Function to read from. I know I need to add to the formula but not sure what to do. Please advice. Images attached. Thank you
Error message generator
Hello, could we have an optimized error message log solution during building process which notifies us of the error? The current blue text box is an absolute time killer during development which could last up to 5 minutes. Bet regards Kristina

Modeling

Discussion List