-
Level 2 MB Sprint 2 DEM03 Growth Rate % Formula
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. Below is the formula I have tried, and it returns invalid. Does anyone have any hints on what I'm doing wrong? Thanks!
-
Anaplan Live!—Your Opinion Matters
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 skills, no matter what level you're at today. Take this brief survey, and let us know what you want to learn more about.
-
Day Of Week
Hello, I want to count the number of weekends between two dates. Do you have a solution for this demand ? Thanks a lot
-
Establish Relationship between two dimensions
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 appear as every time data is downloaded. How can i determine the relationship between both? Is it one to one Mapping or One to…
-
Consolidate Numbered List table
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 dimensions (in black). If i use these dimensions (CF Lines,Driver,Driver Groups) ,the model size increases to a huge extent. The…
-
line item formula Stock Expectations
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 you
-
Stock Expectation Line Item
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
-
Job Aids During Discovery Phase?
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 Anaplan Way. For example, there are great posts here with questions you could ask a client when figuring out what dashboards they…
-
Cannot Create Boolean based on LOOKUP for Write Access Driver
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 that Cost Center: Target Module: Module dimensions: Manager, Cost Center. Line Item: Is Manager in Cost Center? (Format:…
-
Check Which Range a Value Falls in, and Return an Appropriate Value
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 Maximum values in SYS77 (screenshot 2), and depending on which range it falls within I want to pull the appropriate Factor. So,…
-
Referencing Switchover Period
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 Switchover period, I want it to show zero, else pull data from the list. Thanks
-
2.3.11.2 Create DEM03 Saved View for Global Demand Assumptions UX Level 2 sprint 2
What am i doing wrong that only one line item is showing in my view after putting filter ? I have put the filter to view months only
-
Line Item Formula for Stock Expectations
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 the following formula to have the dimension of P2, and still not correct 'INV01 Inventory Ordering'.Safety Stock Exception…
-
Inventory reservation with FIFO
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/reservation based on lot # orders using FIFO algorithm is needed. I’m trying a lot of ways using numbered list and many…
-
Time and Calendars
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 concepts of time and the model calendar and specifically when we have to use a list to represent time Please could you reply with…
-
Formula to count the unique values in a column
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 formula/workaround is appreciated. Thanks Regards Prabakaran
-
LOOKUP MAPPING
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 Target module and I also included the custom verions in my applies to. I tried to lookup, apparently the values that I am…
-
Picklist using System module instead of List
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
-
DigitalCPX 2020: Expert Advice: Model Cleanliness with Rob Marshall
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 will focus on three key concepts: * Performance * Scalability * Maintenance Don't miss the Best Practice article and Guide to…
-
DEM01 Volume Growth Rates Sprint 2 level 2
How to add this filter? Also why not use show selection then filter
-
Level 2 sprint 3 Build Distribution Summary
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 in All region, though I have Stock Exceptions data in INV01 Module
-
how to get a value of last week in a quarter
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 any functions available to get the value?
-
How do I create a reporting forecast FTE module based on a time-dimensioned actuals module?
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 future month should be: Previous total + New joiner that month - New leaver that month. So if I look on the September data my…
-
Update Historic Volumes for Baseline Forecast IN LEVEL 2
Why am i getting error while updating the formula?
-
L1MB - rep02
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 other modules referenced
-
Level 2 Sprint 2 2.3.10
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 formula for DEM03. I am not sure if this is the right answer or not. I imported instead of a formula for FY20 for DEM03.…
-
Save tabs & reopen tabs
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 case I want to continue working with same modules and dashboards, I just click "save tabs" before closing my Google Chrome…
-
Auto Order Lists and API Enhancements - Help!
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.com/t5/Releases/What-s-New-September-26-2020/ba-p/85429 Tag: @Misbah @DavidSmith @rob_marshall @LipChean_Soh @ChrisAHeathcote
-
Rank and Sort List with Child Items
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 the lists in every spoke model when new items are added (because new items are always added at the bottom of the list). To…
-
How to calculate within specific tenure?
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 over 24 months once the project is completed. The 1st month of the recognition starts on the following month once the project…