-
Best way to capture updates on line items and time of updates
Anaplanners, what would be the best way to capture updates to line items and the date in which line item is updated:- the ask is if line item is updated we have to capture the date on which it was updated. So one way I thought of is that if I can replicate the line items with copy line items, and then an action to paste…
-
3.3.12 Activity: Create Product Replenishment UX Page
I'm having trouble editing the final tables in the UX page. After I add the grid cards and link to the modules "SYS00 Time Settings by Month module, Planning Period Filter saved view" and "INV01 Inventory Ordering module grid published to the UX page", the boolean selectors are greyed out and uneditable in the dashboard. I…
-
Timescale - Working days
I really miss the possibility to select Working days as a timescale not only days. I would like to have the possibility to use all of the "time formulas" that is only to be used when you have a timescale. We do our Supply planning on a daily basis but we only works working days the weekends are closed. what we had to to…
-
How to Calculate Forecast period revenue in proportion of actual sales of CY
-
Dynamic calculation on Weeks vs Cumulatebyweek
Hello all, I have a tricky point, and cannot succed to solve it. There is Confirmed orders (already sold) and Forecast orders (we produce in advance because we think we need to have some stock for many reason). My company will produced all the quantities, but not exactly at the correct weeks (sometimes late, sometimes in…
-
Saved View Import Have some code self attached to it
Hi, When I am trying to import a save view from the different models in a different workspace, the save view names are getting added with a hashtag code and the import is also not working, the Error is failed to locate the Save view , Anyone have faced a similar problem?
-
2.3.10 Activity: Level Mismatch on Common Dimension OR Dimension of mapping used for lookup...
I am currently working on the Level 2 Sprint 2 2.3.10 Activity: Create Demand Forecast. In this activity, I need to create a formula which takes weekly growth rates by Product Family in one module and populate them by Product (child of product family) in another module. There is a third module which includes both…
-
Summary Value - Top level not defined in list
Hi, I have requirement in which I need the Total Cash value - which is kind of top level but the top level is not defined in the list configuration so I have tried my best to get the Total cash value for the "Sweep In" checks but unable to get the value without using the select statement as I have to make this list as…
-
Multiple UOM
Hi, For a client we have a setup where we need to plan and report on multiple UOM (liters and units). Currently we're looking into setting this up as following: * Client needs to decide per SKU on a 'planning' UOM. A UOM where all planning for that SKU will be done (inputs, overrides,...) * Create two Anaplan versions:…
-
12.4.2
My REV 03 has the values matching with the course, but they are not getting populated to REP01Country margin Report. Below I am attaching my screenshots!!
-
Percentage Calculation
Hi All, I am facing an issue in the calculation of percentages at summary level.I have a module where I have a percentage calculation field where the percentages are calculated and are imported to another line item from there in the same module. As the second line item displays the option of user inputting the value under…
-
Help us inform the future of Data Integrations at Anaplan
The User Experience Research team is looking for Integrations Admins and Integrations Developers who have spearheaded a first use-case integration into Anaplan to participate in a 60-minute research session. If this sounds like you, we’d love for you to sign up for this research study! You can sign up by filling in this…
-
Forecast to get value from Actual version
Hi All, I am facing a challenge while replicating the Actual selection to Forecast. Can we have a formula where forecast will take the same Boolean selection as actual. In the Column are versions(Not list).
-
Level 1 Model Building Exam - Model Building Activity 5
Hello, I cannot figure out the formula for Bonus and other line items for Level 1 Model Building Exam - Model Building Activity 5 I created the EMP03 Employee Drivers by Role module and added the department and role to it. In activity 5, we have to change the module EMP02 Employee Expenses "Bonus" line item formula to…
-
Previous quarter values
I have the following line items- A,B,C. I need to create a new line item D which should take previous quarter values if C=0. PFA screenshot.
-
Distribution Center Summary UX Page
in Learning Activity Sprint 3, we asked to make a Distribution Center Summary UX Page and when I take the exam, there's a question that I wont be able to answer cause it doesn't match the values on the first grid of Distribution Center Summary UX Page that I've made. The Exam Question (Image removed by Moderators) Here is…
-
Micro lessons not opening up quickly
Hi Community , Need Help !! Micro lessons in Level 1 not opening up quickly , Taking sufficient time . I am in Subject ' Modules ' My internet is running perfectly fine . Thank you
-
Learning style
Hi All! I'm trying to get a pulse on the communities best note taking tool for learning Anaplan, both during certification path and after. I'd like to find a digital(and analog) tool where I can put my learnings and go back to to refresh and learn more. As this is a knowledge industry maybe even a STEM maybe there are some…
-
Invoice amount multiplied by six
Hello Team, 1. We have a model where all the invoice amount is multiplied by six after the latest data is uploaded. 2. Also, I am not sure where the source data is coming from, which I need help with as well. 3. Middle of all this our administrator left as well, so any help link, tips, or material will be appreciated. Any…
-
Filtering Data
Hello Community, In My model building I need a filter. Where if I Check on Monthly data should be available on monthly Basis. And if I check quarterly then it should be available in Quarterly basis so on.. Please help me through this. Regards JEEVAK
-
INV01 L2S3 Formula Help
Hello, I believe my formulas are correct; however, my data does not seem to change from week to week, so I'd like someone to double check and provide any insight. Thanks, Josh G Actual Outcome: Expected outcome: Specifically, line items - Forecast Demand, Suggested Order Amount for month, and ending inventory all seem to…
-
Last quarter of FY
Hi I'm trying to get the last quarter of the FY formula. I have Q1FY22, Q2FY22, Q3FY22, Q4FY22. I need a boolean which checks the last quarter of the FY ie., Q4FY22. Please help.
-
[HELP] Level 3 - Sales Planning Sprint 1 - TAR01 Detailed Sales Target Module | 1.4 & 1.5
Hi Everyone, I've been stuck the last few days working on User Story 1.4 & 1.5 | 5.2 Model Building Specifications. There isn't enough information for me to comprehend what is needed to be done and thus all my numbers aren't correct. I'm positive my other user stories are working as intended based on the examples they…
-
Show 'referenced by' also for saved views
We use frequently saved views to import data from a source module into a list or other modules. A great challenge is to understand where these saved views are used, it is particularly challenging when you import data across models. The only current way is to go through the import sources of each model or use the business…
-
Movingsum function
I am not getting last 2 line of this table .how it is done
-
Sequence of Production Schedule based on Priority and Line capacity
We would like to seek assistance on how we can build a requirement where Anaplan needs to recommend the sequence and volume of products to produce in a line with consideration of line capacity and priority. Example: Data: Line 1 Capacity = 100,000 Products produced in Line 1 Priority Weekly Volume Product A 1 10,000…
-
Statistical Forecasting Discount Factor
Greetings! One of the models in use by my company is the statistical forecasting model, whereby material history comes in through a calculations module and the material is assigned a forecasting method based on the data there. Leadership has requested a change to how the history is weighted that they have referred to as…
-
Finding text substring in a List
Hello All, I have a requirement where my end users are doing some manual text based tagging(excel screenshot below). Within Anaplan, I maintained this mapping as a list with the tagged value as a property. I tried using FIND/FINDITEM of the substring within the Memo TL text line item, but in vain. Can someone help me with…
-
7 Benefits of Anaplan Modeling
Hi Model Contributors, I just read a really interesting Community blog post by @AntonS where he outlined seven benefits of model building within the Anaplan platform (spoilers: #5 covers the benefit of using standard Time and Versions compared to custom alternatives). I thought this would be a useful review for less active…
-
Community perspective: Employee grouping for sales targets
Within sales and target setting use cases, there are often situations that require assigning specific targets to a group of employees. While this can be done manually or through a blanket allocation, it may be more advantageous to designate groups within regions or markets for the purpose of distributing targets. There are…