-
Replace a nested If that has many if's
So i have a nested if statement that checks the status of a shipment. "cancelled" or "storage" first using boolean, the progresses through a series of dates to see which have been added, finally defaulting to "At Origin" if it has not left yet. Multiple IF's are not ideal, but I can't see how I get round this one. Even if…
-
Is there a way where I can update a line item if the value is blank else do nothing ?
-
Dynamic List
I have two list: Target Center and Table Type: When a user selects target center I would like only the centers that are in the table type that is selected. For example if table type "FTE" is selected then Target Center list should be only "Board of Directors, Office of the President, and Legal" and if table type "SqFt" is…
-
From Native Versions to Fake Version List?
Hi All, As it is not possible to SUM down native versions is there a simple mechanism to take data out of versions and restate it within a fake version list? I know this is achievable via a series of nested IF THEN ELSE queries but this approach is not sustainable as it needs to be updated every time a new native version…
-
Consolidating recursive modules
Hi I have 2 Lists and 3 modules as shown below. I want to build module 4 (details below) in the most efficient manner. Seeking ideas. Thanks in advance List: Employee ssL0Employee ssL1Employee ssL2Employee ssL3Employee Employee 1 Y Employee 2 Y Employee 3 Y Employee 4 Y Employee 5 Y Employee 6 Y Employee 7 Y Employee 8 Y…
-
Line Priority Allocation
Hi, I am having issues using the optimizer for production allocation. The model is for capacity planning. Problem statement Need to allocate the SKU demand to compatible factory lines based on the following logic. Each SKU has a production priority and a factory line priority. If the production priority for a SKU is 1…
-
How to convert text name in upper case to lower case
I have a list with employee names all in upper case. E.g. DANIEL SMITH How can I convert these names in Anaplan to Daniel Smith (upper case on the first letter then lower case for the remaining)
-
How to solve this error "Name cannot be mapped for a numbered list"
I am trying to load a csv file containing above properties in to a numbered list. and it throws me an error saying name cannot be named, but in the above case i didnt map the Name, I just mapped the properties. Can anyone please help me where am I going wrong?
-
I want some help in using DCA - Dynamic Cell access
Hi, Below we have 3 line items in a same module, I want to apply DCA in such a way, If I select Country, Sub-region and Region should disable If I select Sub-region, and Country and Region should disable If I select Region and Sub-region and Country should disable. Can you help me in writing the formule for Read and Wirite…
-
Problem in building a dynamic Version to Version Variance Calculation
Hi All, I have a request by a customer to have version to version variance analysis done where, when a version is selected from a drop down for comparison the version name selected appears on the column header. And not version 1 or version 2 NB: Am not using a native version. The version used for the drop down is a custom…
-
Performing Matrix Calculations in Anaplan
Hey, there I'm new to Anaplan and I'm exploring how to smoothly execute a matrix product within it. I have two modules: one resembling a (1,5) matrix and the other a (5,5) matrix. My goal is to perform a matrix product of the form (1,5) * (5,5) * (5,1) to derive a single number. Can this be done directly in Anaplan? If…
-
How to sum on a line item not a list
I would like to sum a line item based upon another line item that is not a list. So for example, I have the following: In this case, bananas is able to be listed twice because it is under different parents/countries. So I want to see the total for all bananas by summing based on the unique ref (which is not a list)
-
Level 2 Sprint 3 Exam
I have tried to take this exam. There are two formula questions where I provide answers that work based on the information provided. However, the system will not accept these formulas as valid answers. (Questions 3 and 9) How do I either have these formulas accepted as value or understand why they are rejected.
-
How can I make a YTD average?
Hello, I am looking to get a YTD calc but I cannot use the YEARTODATE function because I need an average, not a SUM. And previous years should calculate according to their months (i.e. I would see a full 12 month avg for 2023, 5 month average for 2024). My initial thought is to use TIMESUM but am having trouble setting it…
-
Running week of sales anaplan
Hi Team, I am trying to get Running week of sales in Anaplan. Below is the scenario. I have 1500 quantity in current week .. i have a forecast of 500, 500, 1000 for next 3 weeks. want to see value of 2.5wks in running week of sales i.e.based on forecasted numbers . Can any one help on it
-
Level 2 Currency Conversion REP04 Local Currency
I have created model for currency conversion, all went well but at last after I add the formulas its not showing any data. Not sure where I am going wrong.
-
Graph time selection?
Hello, I have a table and a graph based on a table. The selection that I have in Years, Quarters and Month. The Table should move on every selection of Year, Quarter or Month but the Graph I just want to stay only on the year selection. So my graph should show all the month of the year regardless of the selection of the…
-
Dimensions & Lookup
Anaplanners, Been struggling on this particular piece: We have a module where we have a Country Dimension and Serial Number list, as each country has a fixed number of 10 agents and some attributes (line items). Refer Snip: Agent Name & Agent Role are list formatted Line Items. "Country" and "No." are lists. Requirement:…
-
Level 1 Model Building Exam - Activity 6
resolved
-
Default selection in a dropdown
Hi, We currently have a line item (called driver), which is formatted as one of our lists. When a user goes into a UX, they currently have 15 options to choose from, however we want a specific one to come up as default. Is there a way of doing this? Thanks, Josh
-
Selective Access
Hello all, I'm encountering an issue where selective access filters don't seem to be applied to a list (numbered) when it's being used as a column (select list) in my Anaplan model. The selective access filter is configured correctly on the parent object, but it doesn't seem to be filtering the values in the column list…
-
Anaplan List Summaries
Hi, Our model currently has the heirarchy sites > region > are, which is fed through our modules. One of our modules (visible through our UX's) give us price by site, where we can filter by region, but this narrows down the data of sites to the region selected. We want to be able to select 'Region = NORTH', and the number…
-
API Authentication error bc of need to reset password
Hello, The IT team of a client has built a integration with the data base to Anaplan using the API. They have a problem of Authentication when Anaplan ask to reset the password, giving a 401 unauthorized, so they have to go to the Anaplan page and reset the password and make the changes on the integration. Is there any…
-
Display Year Sum Value and All Year Period while in filter mode
Hi all. good day. may i know if it is possible to display only the sum year value and all year period value while in filter mode.
-
How to create in a module a quarter option?
Hello, I have a forecast module, with monthly TimeScale and I want to create, in this module, an option for a quarterly view. So basicly, if the client wants to see the data quarterly, he should be able. I also have a MOD02 Quarter Time Settings and also a filter module for the quarter part. At this moment, my data is…
-
When I make a copy of model, what does not get saved?
What are the pieces of information that does not get copied to new model when copying a model by using the "Manage Models" screen and how does it compare with copying the model by revision tag When model is copied by revision tag, production data is not copied. When model is copied by "Manage Models", I think history and…
-
How to check if the text in the line item exists in a list?
Hi Guys! I'm trying to build a formula where I basically need to check if two conditions are true. One of these conditions is to check if a certain text from a line item exists in a separate list that I created. Bringing it to a language that I know more (I'm new to anaplan) I would like something similar to IF LineItem IN…
-
I cannot start Level2 spint2 learning
I completed the test with a 90% response rate. But I can't take the next step. What action do I need?
-
Create DEM03 Demand Forecast Module: Growth Rate % line item zero values
Hi Anyone who can help me with the formula for "Growth Rate %" line item? I put this formula ('DEM02 Volume Growth Rates by Week'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family]) but I have zero values
-
Running Actions in a Loop (Conditionally)
I have a use case to simplify let take an example. Assume we have product that can be bundled. Product A is single SKU. Product B is bundle of Product A plus some extra cost (eg packing cost). Product C is bundle of Product B plus some extra cost. User has option to either modify the price of Product A or Modify the extra…