I have been stuck on this activity for the past 2 days and do not know what I am doing wrong: This is the formula I tried for Bonus: For bonus: IF Employed? THEN Salary * 'EMP03 Employee Drivers by Ro…
Hello! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and…
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…
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…
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…
Currently looking to make use of the feature where can now see the calculation effort entailed in certain line items and I've already been able to eliminate or refine a number of elements in various m…
Hello all, I need to rename a line item in a large model, I am wondering what are the best practices to do this? What should I consider before renaming to avoid destroying the model? Thank you in adva…
I am needing to convert month to text as we have a specific nomenclature we use for our company (i.e, if the current month/pay period is May but the pay accrual month is April I am needing to have a t…
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…
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
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…
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…
