-
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…
-
How to Create Reporting Version
Hi, I'd like to see how I can create (2 different) reporting versions; a mid month ROF (rolling operating forecast) version and a end of month ROF.
-
How to Define the current week in anaplan
Hi, Is there a possible way to define the current week in anaplan and current week should change automatically. without updating the cycle
-
Nested Ifs for Commission Calculation
Hello i would like to set a basic if nested formula for estimating let's say commissions . If my limits are in units : 0-300 commission 0.2 301-500 commission 0.25 700 and above commission 0.30 Whats the correct syntax : (if Units Sold>=700,0.30,if(Units Sold>=500,0.25,if(Units Sold>=300,then 0.2,"Zero"))) whats the…
-
Average Of Flat List
Hello All, Is it possible to find average of flat list. If it is possible please help me with it. Thankyou in Advance Regards, JeevaK
-
Workaround for select in LIS Collected.
Dear Team, I would like to ask for a workaround in case where I had to Compare the different versions(Custom) side by side to show the variance and growth without using select. What I did are the following: 1. In my report Module, I made the GL as line item (Revenue, COS, Gross Profit) for some reason. I have also…
-
MONTH into Weeks with suitable example
I am Having Query, in model building i have set the calender to months. but i want to see data in weeks what i have to do see weekly data and what are functions can i use or by changeing calender data loss pop-up is shown. can anyone please share the answer for bove question
-
How to add badges for earned certifications?
I have completed all the training and earned the Anaplan Certified Model Builder certificate but there are no badges reflecting on my profile. Please advice.
-
New UX Filter not Applying (?)
This has happened to me in several instances while migrating to NUX, and I am wondering if anyone else has experienced the same thing? When I go to add a Boolean filter, for whatever reason, I cannot apply it (see .gif below): I have no issue applying this same Boolean filter in Classic Dashboard. Can someone explain why…
-
Pulling data from one module to another when time is the only matching dimension
Hi, I need to pull period data from one module to another but the only dimension that is matching is time. What formula can I use?
-
Advice on steps for building a Anaplan Model from scratch
Hi, I'm going to be building a Anaplan model from scratch and would like advice on what order my task and steps for building the model should be to make sure I'm building most efficiently for Anaplan. I have already created a Schema using the DISCO method for Anaplan, and also created a timeline with task that will be done…
-
Selective access
Hi All, I have a scenario where I have 2 lists (Business service and Countries). Both have a parent hierarchy built in with 3-4 levels. I am being asked if we can mix and match selective access but I believe thats not possible. I cant use a dependant list as the lists are too long to paent to eachother (I have >200…
-
How to delete years rather than hiding them
Hi, I only want to show one year for my balance sheet however when I created the module I see six (we need six years for revenue and expenses). Is there a way to delete the years not needed or is the best option just to hide these? Thanks, Tom
-
Can i set line item name dynamically
Hi, I am looking for a line item name change based on another line item value formatted as date. For example Line item name : "Price based on "DD/MM/YYYY", this line item name should change based on value entered in another date formatted line item. If I enter date value as 01/03/2021, then my first line item name should…
-
Create subset in list based on subset from another list
Hi, I have a List 1 where one of its properties from List 2 In List 2, I have a subset which is manually created and not expected to change I need to create a subset in List 1 such that it will be automatically checked based on the subset ("GE" in pic above) in List 2. how can I go about doing it?
-
Finding Minimum
Hello All, Here I need to find Minimum of values in Expansion. But I dont need zero to be minimum. ExistingExpansion14016181820202222243401400000 Please help in finding the minimum. Suggest the function for the same. Regards, Jeevan
-
Using an Anaplan Model to manage User provisioning
Hi All, I am looking to explore the feasibility/how-to of if a anaplan model can be used to manage Users, & Roles. The goal is to centralize the security management, almost as it it were a "data hub" that would then push the user roles to the other spoke models. Has anyone implemented something like this or know how this…
-
TEXTLIST() vs [TEXTLIST:]
Hi All, I have read and re-read @rob_marshall's (and Planual's) cautions against TEXTLIST but wanted to check if there is a performance difference between Textlist the calculation function and Textlist the aggregation function? Maybe a performance difference would come basis how the functions read the data? Planual doesn't…