-
Hide certain list member in dropdown
Hi, Is there a way to restrict user access in certain list but they should still see the amount when being aggregated at total list. I need to restrict user to all modules so using the picklist would be little tricky as I need to update everything. Thanks in advance for helping. Tom
-
Ratio of each accounts product sales by country's previous year actual sales by Prod Family
Hello, This question is related to user story 1.3 and 1.4 We want revenue for each account by product. Further we want to take its ratio against country’s previous years actual sales revenue by product family. Are we looking at a module with dimensions of Country, Product Family , Account & Time (Quarter) to calculate the…
-
3.3.5.3 check your work
Need some help please, as per example, Safety stock target line item is blank In my module have got summary values here, any pointers please?
-
stuckon level 1 exam question 7
hello can you help me please i don't understand why i have 0
-
L2 Sprint 3.3.5.3
Good day I am working through sprint 3 at the moment and all is going well. However in activity 3.3.5.3 INV01 Inventory Ordering "Check your work" I have noticed that my amounts are slightly off when compared to the screenshots. (usually by a factor of 2). Can anyone help and explain why this might be and how I may correct…
-
Average for a Period of Time for Next Period
Hi Team, I am trying to calculate the "Average" for a Expense for the Period of "FY24". And I want to calculate using the Average from Q3 FY22 to Q2 FY23. On the "actual line items are the expenses for prior quarters and on "RunRate Line Item" I want to calculate the Average for those 4 prior quarters. I am try TIME SUM…
-
How to make a line item a Subsidiary view
Hi, I'm having trouble making this specific line item in a module into a subsidiary view, in picture attached. The line item i want to make a subsidiary view is Territory. Can i please get some help? Thanks! Amanda
-
Level 2 Sprint3
Hi, At the end of Sprint 3 there is one lesson which says to Create Product Supply Manager Role so can anyone please help me how to do this lesson and what to do in this.
-
In L1 Model Building activity 5, There is an error when updating the Bonus formula in EMP02.
Hi, Can someone help me where am I going wrong. As the error is data type mismatch. Please find below screenshot. Thanks in Advance.
-
Add DCA to INV01 Inventory Ordering- L2 sprint 3
Hi, I am facing doubts in Add DCA to INV01 Inventory Ordering module in L2 Sprint 3 so can anyone please help me how to create DCA formula. It would be great if anyone can help me with this, attaching the course screenshot and the module that I have created according to my understanding.
-
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…