Hello, I have a module DEM03.1 Mapping (CV&ADI) with Time dimension and LIST03 SKU with the same List but without time. I'd like to get first non blank value from Date of introduction Line Item in DEM…
I want to create a functionality where the end user will select a start and end month from a pick list and based upon the difference in months Anaplan will calculate the average revenue. Revenue data …
I have a module called FX01 Currency Rates. It has 6 Currencies and their rates for 2024, monthly. I have another Module called REV04 Sales Volume Budget. where by customer and SKU there's an input fo…
In the world of Anaplan modeling, performance is key. Slow model calculations can be a major bottleneck, impacting productivity and decision-making. But what if you could pinpoint exactly what’s causi…
Hello Anaplanners. I have a module dimensioned by Month, but the Time Summary for my key line item is set to None to optimize space. However, I need to bring this data into another module that is dime…
Hey, new here and starting out with the Model Builder I course. In Lesson 6 there is shown how to download the Formular and Function App. Unfortunateley this Video seeems outdated so i can't find this…
Hi Anaplan Community, I recently updated a custom time range in my model and noticed an unexpected increase in model size. Previously, my custom time range started in FY22 with 4 periods, and the tota…
Hello, Does the "Anaplan Formulas & Function" app still works? When clicking on "Download this app" I'm directed to a page "HTTP Status 400 - bad request". Thanks, Evrard
Hi, We came across org charts (Hierarchy Charts) which are a great functionality. However, we want the client to be able to do scenario planning on the hierarchy and by Month. E.g. John could report t…
I am in the middle of a model build and am running into a situation where I feel like there should be an efficient option to do a calculation, but I can't figure out a way to do it without a 'staging'…
In as much detail as possible, describe the problem or experience related to your idea. →Anaplan can autocalc on an area, but it cannot autocalc between cells that are not adjacent. I want to be able …
Hi, How to forecast data for future months? I have data for FY23 and I want to forecast the Sales for FY24. I have two line items: Sales and Quantity. Is it also possible to forecast the two of them? …
Hello, I have the following problem. I am trying to associate Customer Part Number, which is a unique product code in the customer's store with the SKU that exists in my store. For example, the custom…
I need some clarification on how/what the SLA function is calculating. Here I have an example of a call center planning scenario where I first input an SLA, Target Response Time, Average Arrival Rate …
Hi, Could someone please help me with the following? Solution DEM04 should be this: My DEM04 Demand Export: My values are way higher, Demand line item is not for each product SKU. How can I fix this? …
Hi Everyone, Can anyone confirm which of the below is faster? Final Line Item = Module A. Line Item A [SUM: A, SUM: B, SUM:C] + Module B. Line Item B [SUM: A, SUM: B, SUM:C ] Line Item 1 = Module A. L…
How can we do interpolation in Anaplan? I need to interpolate scores from the following criterias: a. Min number with equivalent score b. Max number with equivalent score Thank you!
Hello Anaplan Community, currently we have a very simple statistical forecast tool in Anaplan. We can select between 15 forecast methods for a forecast category. We generate the statistical forecast u…
Hello, I have one requirement where line items should be filtered based on the Year(FY24, FY25) Dimension. For eg: there are 12 line items, which contains both text and number formats. If User selects…
Hi all, Was hoping to get some insight into the performance implications of obtaining the year value of a line using either YEARVALUE(x) or x[LOOKUP: FY]. Both will retrieve the same result assuming s…
Thinking through the results of a modeling decision is a key part of ensuring good model performance; in other words, making sure the calculation engine isn’t overtaxed. This article highlights some i…
First Module List: SKU's Dimension : weeks Line item: Volume Second Module List: 1- 100 ( a list of the numbers 1 to 100) Line items: Start week, End week, SKU, Item I want a timesum in the second Mod…
Referring to the previous item in a list is a nightmare: You can write a lookup to find the previous item, but as soon as you try to use it you get a circular reference. Sometimes you can get round th…
One of the best things about anaplan is the ability to drill through the model to see where values come from. sadly, anaplan is now quite limited in how you aggregate over time. at some point changes …
In Level 2 Model Building : Conclusion, there's an 'Activity: Prepare Data Exports' that tell us to Create Shipping Export Module and Create a Saved View. I've made the formula and choose the format a…
Hi Anaplanners, i am stuck with one the calculation ,which requires me to calculate WEEK NUMBER of a date in the year.In excel we can use WEEKNUM Function to get the number of the week . eg,WEEKNUM(20…
*Content reviewed for accuracy June 2020 Making sure that production data lists are correctly marked within a model is a key step to setting up and using Application Lifecycle Management (ALM). This g…
Hi I want to use Timesum function. In this page, we can use Timesum function with end date to start date. https://community.anaplan.com/t5/Idea-Exchange/Dates-in-Timesum/idi-p/89565 But in Anapedia pa…
