Hi , As per the screen shot, in the left grid whenever i select the y the the left grid should show the same year start month and end month and if i select the y-1 ans week 44 the value then the right…
In the following article, I would like to discuss a common case of model building: the LOOKUP function doesn’t work with summary elements of hierarchical lists. Among other things, this forces model b…
Hi everyone, I was wondering if there was a way to make it possible to edit the values of a line item that has a formula. The most obvious way and that is taught in the Model Builder training is to do…
Hi All, My issue is that I'm using a graph to show the P&L, but my 3-year trendline is spiking, when set to Q and Years. So I have P&L line items calculations and they are connected to different modul…
Hi everyone, I appreciate any help that can be provided, I was very stuck on the formula for Shipping Method. I was trying the formula below and getting error "Format of mapping used for lookup doesn'…
Hi, I'm trying to create a formula where it will create a % based on taking my States List parent by each individual state. The formula I have so far is Total Collections / Total Collections[SELECT: S…
Hi All, So we have a list say Project phase with three list items in it: Project phase> ALL - Design - Implementation - Done This is how page selector in dashboard looks like and the data tables also …
Currently, using SELECT statements in formulas for native versions - Actual/Forecast. But, this will not work with ALM, so what should be an alternate approach for looking up native versions in formul…
Hello, I have a module with many line items, and I want to filter on all line items that contain a specific word (e.g., "home"). How can I do that? Thanks a lot!
Hello, For the line item "Stock Exception", here's the formula I wrote: 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Product, SUM: 'SYS08 SKU Details'.Distribution …
I would like to request that when a new line item is added into a module, rather than defaulting the format to Number as is standard, it defaults to "No Data". Immediate ROI: - Automatically won't toa…
As a model builder I want to have the ability to relabel the time dimension using a specific property/alias so that I don't need to create extra complexity and I can use all the benefits/functions of …
hi Team, I have text lineItem (Role change from ASN) and second linitem (Role ID for ASN Role) applies to subset, I have a boolen value (Bu role?) that need to be true if text value is present in subs…
Hi. We have a requirement, in which the customer wants to plan a given number of units to be sold by a monthly curve, in which you only have to plan whole units, i.e I have 45 units and the % of the c…
Dear Community, I want to use the Anaplan Optimizer to optimize planning/capacity utilization across our supply chain. Got inspired by this link which shows that the Optimizer can in fact take time in…
So basically I need help in the formula for arriving in the 'Final' line item. I tried using Previous formula but I am missing something in the logic. Thank you!
In Sprint 2, Create Demand Forecast, "Remember that Anaplan can automatically aggregate data upwards (from lower to higher levels) in the hierarchy, but in this case you will It is necessary to use an…
Hi Team, I am planning to compare list item from LIST A with lineitem Assignment code (text format) in same module. if item present in list A boolean line item in same module will return true else FAL…
Hi Team, Please refer the image below. The above image shows two grids on the page. Both have same list dimension. I need to build a logic that dynamically changes the items in drop down in the right …
I know that the ALM has draw Back of Selcect Function.BUt, I want to understand why the Select Function Is DRaw Back and why Can we use the Select Fucntions in Production lists
Hello everyone, Want to use the Anaplan Optimizer across time, and have found out that I can not use a line item running on the native time scale in Anaplan. Hence I am on the quest to create a list o…
I'm having issues counting the current headcount by month. I have employee hire date, leave date, and projected leave date. I've attached snap shots of my modules. I haven't figured out how to include…
Hi, I'm trying to Calculate what my average would be in a certain month using a rate curve. My rate curves are inputs that are located in a inputs module and I believe I would need to multiply them by…
Hi Community, I am working on this use case. Wondering if this is possible. DAT01 Emp Details Emp | Start Rate EmpA 15 EmpB 16 EmpC 17 SYS02 Zone Module Zone| Lower Range | Upper Range ZoneA 14 15 Zon…
Hi, I have system module for time settings, and based on Today's date line item I'm trying to set Planning year which is current year + 1, when I'm selecting date between jan to dec 2022 it is showing…
Would be great if Anaplan has a Formula Evaluating Functionality similar to Excel. We build a lot of multi step complex logic in Anaplan and only the final result is shown. Excel spreadsheets allow us…
Hi, I have LI's from one Data Module that I need in another Data Module that doesn't share the same dimensions. The common mapping I would use would be BB Contract ID. What would be the best way to go…
