-
RANKCUMULATE Tranches with a "Not to Exceed" allocation
Module contains Investment Tranches maintained as a list as well as multiple investments as a separate list (Whole Dollar). A fixed $ Credit is input in a separate module, but then should be allocated to the lowest tranches first - any excess credit is carried into the next tranche up and so on until the credit is…
-
SUM based on boolean at child Level
I have 2 lists 'BU' and 'Projects' , where Projects is child of BU list. 1. 'Projects Module' is dimensioned by Projects List 2. Another Module 'Bu Module' is dimensioned by BU List The Amount Line Item in this module pulls data from 'Projects Module' summing it up by BU and quarter 3.Here I want to sum the data only if…
-
Model Optimization
Blueprint Analysis Model Analysis techniques using Excel What? A model analysis technique using metadata from your Anaplan model imported in to Excel; utilizing purpose built formulas to identify line items of interest. Why? We do this so that we have some extra information to arm ourselves when trying to optimize a model.…
-
List - Top Level
Hi, I have a small query on Top Level (List). As per best practice, we should try to avoid Top Level for large list. Instead, we should use Lookup for the same I'm trying to use Lookup for a formula & its still asking for Top Level. When I update Top Level, the formula works perfectly (with Lookup). Is there any alternate…
-
Start and end date of employees module formulas
HI, I am created the SYS employees modules setting in that i have line items Start date End date so my doubt is that can i use Formulas to that line items employee start date and end date what formulas can i use in that SYS employees module. please give me the example with it.so it will be helpful to improve myknowledge.
-
Looking for text in modules
Hi, I need some orientation on this: I need to look for a text in the column "P2 product Brand" (first photo) in another module (second photo) and if it is there, I need to return TRUE otherwise False this formula should populate the last column of the first photo. Both columns are formatted as lis, and they are populated…
-
Hiding display name for certain users
I have a model with sensitive HR data, and I need people which should not have access to identifiers of individuals to be able to enter data. I have a list of employees, and I need, somehow, to build a dashboard which I can give other business areas access to, so they can enter forecast data. The problem is that they…
-
How many dimensions can we use in Anaplan
I am the beginner so i would to know about the how many dimensions can be used in anaplan and please let me know in details or other market committers have using not more than 30 dimension.
-
Time Filter - Current Period
Hello, I have a module which is NOT Time dimensioned. I have a line item named as "Year Filter" with Time scale as years and Boolean formatted, formulae with different conditions in the same module. When I apply the "Year Filter" in the saved view in the same module, I DONT see "Time: Current Period". It shows specific…
-
Creating code for numbered list
Hello all if I need to create and add code to already existing numbered list. What are actions to be taken. I understand list should be exported to excel and then create code and reimport to model but how to create code? What’s the best practice to ensure uniqueness. Thank you
-
Best practice for supply chain route planning?
Dear, I am building a supply chain planning system, which has different order types. Depending on the specific order type it has to hit only specific workcenters in a specific sequence with specific lead times. I have created a list with the different order combinations, e.g. "ProductA_Wood_Black" And also a list with the…
-
Convert Numbered list into text
Hi, I am having a hard time trying to convert a numbered list into a text value. I have used the NAME() Function, but as a result I get the Number assigned to the list member. Instead I would like to get the text value of the Display name. The reason why I am trying to do it this way is because I need to Concatenate the…
-
Data type mismatch: format other than LIST or DATE being referenced as a relation
any suggestion on how to resole above error
-
List parent in module along with time columns
Hi there, I would like to add a parent column for the list in my module. I want to create the following module which shows the list parent in the second column: At the moment I have the left and right side of the image as that part is a straightforward pivot: Page = volumes line item. Rows = Customer-SKU list, where…
-
Manual Filter for a Hierarchy
Anaplanners, Had a table that displayed different layers of the hierarchy. Layer 4 rolling up to layer 3, layer 3 rolling up to layer 2 and so on. If i as a user select layer 4 then only layer 4 needs to be displayed in the table. I know there is a native anaplan functionality where we can select the hierarchy but we…
-
Optmizer issue - "Could not parse Optimizer configuration"
Dear experts, I'm trying to create an Optimizer, where I'm defining the Objective, Inputs and Variable. However, I get an error "Could not parse Optimizer configuration". Is it compulsory to define the constrain in it? Can you plz suggest what could have possibly gone wrong based on the error message. I tried to search any…
-
How to insert member in a list in between an order using actions?
I have several lists which are needed to be updated by users. So, I have created a module with a flat list (contains numbers 1,2,3.....100) and line items with these lists names. Created saved views with one column (i.e. List named line item) and imported this column data in the list. Added a "Run import" action button so…
-
Anaplan Live! Model Contributor Meet Up
Attending Anaplan Live next week, in San Jose? Make sure to swing by our Customer Connect meet up, specifically geared towards Model Contributors of all levels! Our own @rob_marshall will be leading a relaxed conversation and connecting attendees with similar backgrounds. Sign up today. Unable to join in-person? Make sure…
-
Count in numbered list
Hello everyone, I am facing a problem in counting the same names in numbered list. Let me explain with pictures, I have a numbered list :- Style. In this list, every member has different code but multiple members has the same Display name property as shown in the picture below. I have a module "Module M1", where this list…
-
Finding blank cells in a number line item
I want to filter by a number line item to show just blank cells, but I cannot figure out how. I know the ISBLANK function is what I want to use, but it cannot be used on numbers. Is there a way to find blanks in a number formatted line item similar to the ISBLANK function?
-
Alternative for SUMPRODUCT
Hello Community, Is there any Alternative function as SUMPRODUCT()... If there any method please Suggest.... Thankyou In Advance. Regards, JeevaK
-
Count Filtered result
Hi everyone, I have two modules, let's say M1 and M2. In M1, the dimensions are Users and Activity (List of activities). In M2, the dimensions are Styles and Time. I have made a filtered (Style filter) which filters styles in M2 according to the selection made by the user in M1. If there is no selection made, M2 shows all…
-
How Nested Formula affect performance
Hi, I want to improve modele performance. I'm trying to improve IF statement. Here is two statement. Answer1 : IF A THEN IF B THEN 100 ELSE 50 ELSE 0 Answer2 : IF A AND B THEN 100 ELSE IF A AND NOT B THEN 50 ELSE 0 The performance of Answer2 is always better than Answer1? --- Another nested Formula affect performance? This…
-
Pull values from one module to another module
Hello All, Consider 2 General List List 1 Has A,B,C,D,E,F List 2 Has A,B,C,D,E,F And 2 module in which module 1 have dimension List 1 has value A=100, B=200. C=300, D=400, E=500, F=600 And module 2 have dimension list 2 I want to pull values of module 1 to module 2 how it is done... other than lookup Thankyou In advance…
-
Update the Summary Method Setting
In Level-1 under "8.8.4 Activity: Add Formulas to Size, Margin Report Module" why do we need to change the Margin % line item Summary Method setting to Formula. What is the outcome or output of this change? Is that a major impact on output?
-
How to calculate the 50th percentile
Hello, Do you know how to calculate the 50th percentile (or any percentile) in Anaplan? Thanks! Arnaud
-
Dependent Dropdown Not Available
I'm trying to setup a dependent dropdown for a line item that is a in list format where the list is a numbered hierarchy (mid-hierarchy). When I select my hierarchy level from the list, the checkbox for dependent is grayed out (all filter checkboxes are unavailable). Help!
-
Map multiple list member to single member
How can we map multiple list members of different fiscal year to single list member fiscal year. Both the line items are in same format
-
Modules for Dashboards
Hi, I have a question about best practices for setting up Modules for Dashboards. Currently we have LI's from different modules that we would like to display on one Dashboard. Is it best practices to create a Output module for a Dashboard and that will have all the different LI's in one place from those different modules?…
-
How to Compare Text of One Module to Another Module with Different Dimensions
Hello, I have 2 modules, each is using a different dimension (numbered list). Both modules have a line item which is a text. On the 3rd module that I'm trying to create, which is going to have the same dimension the same as either of the preceding 2 modules, I need to retrieve the text line items from both of the 2…