-
Translating % correct into a RANK()
Hello, Question - I have a module to calculate the percentage correct (e.g. 75%) and I want to be able to rank this on a scale of first to tenth place. Advice on how to do that? I tried using the RANK() with the module calculating the percentage correct and could not get a solid translation. Thanks in advance!
-
To display code of Child and parent in a single line item
Hi, Is it possible in Anaplan to display the codes of both Child and parent in a single line item. I have requirement to show the code of both in the same line item. If its Boolean then Any or All summary would work since its text and the list would be at child level I can't apply Formula as a summary so any work around…
-
Level 2 Sprint 3 - Inventory Ordering Module Formulas Module
Hi, I have created the two boolean value but I am having problem while creating Beginning Inventory. So can anyone please help me with the correct formula and data.
-
hotw to obtain period of line item
Hello, I'm stuck on a formula that seems obvious to me. I would like to retrieve the time period of a line item : Week : list formated. time period by week : format time period, applies to week => i want to obtain time period for each week. Any idea? thx for your time !
-
Demand Forecast Detailed Demand Grid UX.
Hi, I am having problem in Level 2 Sprint 2 - DEM03 Demand Forecast Module in creating a saved view as I am not getting what they are saying to do. So can anyone please help me with the correct formula and data.
-
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.