Hi! I am working on the DEM03 Growth Rate % formula. I feel confident that the formula involves a lookup to SYS08 to find the Product Family, and I think the source is DEM02 Growth Rates by Week. Belo…
We're getting ready for our next Anaplan Live! event. As active Community members and model builders, your input is extremely valuable. Our mission is to bring you content to boost your model-building…
Hi All, I am trying to figure out the mapping that can exists between two dimension that gets exported from the data base. One dimension is Profit Center and other Customer Code. These two columns app…
Hi All, I needed some help in designing a consolidation table for the input table as attached as image. i am trying to consolidate the Org Var based on CF Lines,Driver,Driver Groups for the fixed dime…
Hi, need guidance with the following formula. 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS04 Product Details'.Product Family, SUM:'SYS07 Distribution Center Details'.Country] Thank…
Hi, Confused with this formula. I have the following below. Please advice. 'SYS07 Distribution Center Details'.Country[SUM:'SYS04 Product Details'.Product Family] Thank you
Hi Everyone, Are there any documents/job aids that summarize the key questions to ask clients during the Discovery Phase? I'm referring to more specific questions than the broad overview in the Anapla…
Hi, I'm trying to build a module with a line item boolean looking if a Manager is in a specific Cost Center to later work as a Write Access Driver if a Manager can do certain actions in relation to th…
Hello, For each list member in SYS78 (screenshot 1; "Rows") there is a corresponding Baseline value. I want to have the system compare the Baseline value for each list member to the Minimum and Maximu…
Is there any way in a formula to reference the Switchover period for a version? The module is pulling in data from a list across the time periods but if the cell is for a time period prior to the Swit…
Hi, I used the following formula and it says the dimensions do not match. 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS07 Distribution Center Details'.Country] After that I used the…
Hi experts, I’m now struggling inventory allocation with FIFO algorithm. The requirement is automatic inventory reservation with SKU lot level expiration date as below. Automatic shipment allocation/r…
Ok, I know I am going to open the flood gates here, but we are looking at the functionality of the whole time concept in Anaplan. I'm asking for help in capturing the challenges with the current conce…
Hi In the attached screen shot of my dashboard,I want to count the number of unique values in the Item column and display the count value near the title 'Comp Reservation Details'.Any help for the for…
Hi, For your assistance please. I created system mapping module for custom versions (List: Actual, Budget and Reforecast). Scenario: I want to get the quantity difference of actual vs budget, in my Ta…
Hi, Is there a way I can use a system module as my driver in the picklist ? Apologies, I can't find any related topics on this, please share if there are any. Thanks in advance. Tom
It’s not too late for Spring cleaning! In this session, review and follow guidelines to effectively clean-up your model and optimize it as you build. https://www.youtube.com/watch?v=Vdrzgsbd3no We wil…
As per the activity I need to display Stock Exceptions I am able to get Stock Exception for a product according to the Distribution Center But, I am failing to display Stock Exceptions for all product…
please help. we have scenario to get the value of a numbered field of last week in a quarter. For example we are in Q 1, we want the value of week 13 (which is last week in first quarter). do we have …
Hi, I have a monthly report for employees actual FTE, start date and leave date. I import this into a module: * Dimensions: People, Time * Line items: FTE, Start Date, Leave Date The forecasting for f…
I'm having trouble with level 8 Rep02 I'm getting the following error: Data type mismatch: format other than LIST or DATE being referenced as a relation I hope you can see my screen print with the oth…
My DAT03 works perfectly, but sometimes it shows as Zero on the Offset Volumes. I think this is because the formula being too heavy. It is funny as I think I did a work around instead of the required …
As Model builder, I work with multiple modules and dashboards. After lunch or in the morning I need to search for all modules and dashboards I am working with and open them again. IDEA DESCRIPTION: In…
Anyone know where I can get the instructions on 9/26 release notes to automatically reorder lists and what the API enhancements are? Looks like some game changer upgrades! https://community.anaplan.co…
We have a list within our Data Hub that needs to be sorted in a very specific order. We import this list into several spoke models on a recurring basis and in the past we've had to manually reorder th…
Dear All, I am looking for the best solution how calculate/distribute an amount within specific tenure once it was triggered by a variable. Example: 1 million of revenue will be recognized equally ove…
