-
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…
-
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…
-
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…
-
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…
-
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…
-
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.
-
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…
-
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.
-
Ranking of Formula Performance
Is there any 1 place that does all the rankings of formulas in terms of performance? The formulas I am trying to rank are…. Moving sum, YTD sum, cummulate, and timesum. In ranking fastest to slowest, I would guess…. YTD Sum, Moving Sum, timesum, cummulate.
-
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…
-
What to do when Sync is incompatible?
When an ALM sync is incompatible, is reverting prod to last revision an acceptable way to fix the compatibility issue?
-
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…
-
Level 1 Model Building Exam - Activity 6
resolved
-
1.6.3.1 Create DAT04 Distribution Center Parameters Module
I don't find SKU flat list. What did I missed please
-
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
-
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…
-
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…
-
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…
-
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
-
Between Anaplan Time Range and Model Calendar, which is the optimal approach for model optimization?