-
Level 2 Sprint 2 - DEM03 Demand Forecast Module
Hi, I am having problem in Level 2 Sprint 2 - DEM03 Demand Forecast Module as I am not getting proper data so it's a request can anyone help me with changes as Override Forecast should have value as 62 but I am getting it as 60 and I have also attached the blueprint view. So can anyone please help me with the correct…
-
FY Values replicating QTD Values
Hi Anaplan experts, Maybe you can help me with my issue? I am building a module that requires to show the current quarter (CQ) as a YTD value without summing up as FY. It means that if selection is Q1 or Q2 or so forth, FY value should be whichever the month or forecast month selected. Sample ss below: Hope you can help…
-
Reverse mapping
Hi all I have a source module with dimension list A and an output module with list B. To bridge this, I have a simple third module where the end-user can input the mapping between A & B. This works perfectly for a standard LOOKUP formula. I was wondering if there's an easy way to reverse the mapping? I basically want…
-
Need to remove duplicated text values from a text Line Item
Hi Members, I have an requirement of identifying unique values of customer in each department. Please see below module which is have a dimension of departments list with three list items(D1,D,2,D3) and a line item(Customer Names) which is having concatenated names of all customers in each department with delimiter as ",".…
-
Level 1 Model Building exam Activity 6
I dont seem to understand what am i doing wrong in this Please HELP!!
-
Need to break down Module into Multiple column Flat List
I need some help breaking down data that has been inserted into Anaplan via the excel add in, so that each component in the existing module can be listed as individual line items as in a data list. The attached photo lays out the dimensions I need, but I'd like to see it in a form that has the Cost center, Ledger code,…
-
Only want user to put in one value
Here's the situation: I have a module with two Boolean line items that should act as the inverse of each other. As an end user, I should not be able to click both boxes. Screenshot below Basically, If the user picks the home team to win they should not be able to choose the Away Team to Win. I thought IF…
-
How to use FINDITEM for a concatenated string
Hi all, I'm a new Anaplan user and have a question regarding the FINDITEM function. I have currently have two numbered lists (1. Account List & 2. Raw Data List) and I would like to use the FINDITEM function in the Raw Data List to match the account ID in the Account List. However, the account ID in the Raw Data list is…
-
nested Sum if
Hi, I need to get total of selected roles occurrence which can fall in three different categories. For example, among all the users , I need to count how many users have role of ADM, and then if they had the same role 3 months ago also- If yes it will be counted in No change list ( Category 1) and if their role is changed,…
-
Searching special character using "FIND"
Hi All, Just want to clarify if I can use FIND function to identify a special character. So I want to check if the string contain "@" ; the logic I am applying is: Line item 2 = FIND("@xxx.com", Line item1, 1) But it is not giving me the result. But works fine when I am setting the formula without "@". Line item 2 =…
-
6.8.3 issues on code
hi team i m trying to add code text by using CODE(ITEM('G2 Country')) but in toggle mode, it not show code
-
Time Filter - Quarters and Year only (not half year)
Hi, I would like to only show quarters and the full year value (not half year values) for the current year. How do you create a time filter to only tick the quarters and year in the current year but not the half years. Thanks.
-
Count redundant word in a text line item
Hi Team, Is there a way to count a redundant words in a text line items? for example, I want to count the word "Anaplan" in a nested text line item that contains: "Anaplan is a cloud based tool. Anaplan can be very useful in planning reports". Is there a way to get a result "2" here. Appreciate your help. Thank you, Elaine
-
Forecasting
Hi, I have 48 months of historical data in my Personal Project and need to forecast for the next 12 months. I believe that Anaplan has AI feature. How can I achieve to forecast by using that feature in my model? Any ideas or examples? Thanks in advance, Mark
-
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…
-
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…
-
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:…
-
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…
-
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).
-
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…
-
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…
-
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…
-
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…