-
Calculating Levels in Hierarchy / Filter out sub-level
Hi team, We have a 5 level composite list & in the top level (Region L1) there is a sub-composite list (by that I mean there are list items with parents within the same list, i'm not sure of the technical name for this - see attached screenshot where China, Korea & Japan are child parent of Asia, all within Region L1) I…
-
Revenue Formula is not working
Hello I am stuck here, not able to add formula. Error is unit price is not a valid item. " 'REV01 Price Book'.Unit Price is not a recognized line item or list member Thanks-Pooja
-
Filter for both List Items & Parent Item on 1 view
Hi team, I'm trying to create a view whereby I filter on all list items for 1 section & then on the Parent list items in another 1 have 2 lists, being GL & Subsidiary both on rows. My requirements are: - For the GL List Item GL.Sale I wish all Subsidiary items to display - For all other GL List items I wish only the Parent…
-
L2 1.5.6.1 DAT03 Level 2 Sprint 1
Hello Community, I am currently having difficulty figuring out where I have when wrong with the L2 DAT03 Historic Volumes module. The lesson states that the time frame is FY19 (which I have selected), and I have imported the csv file fine, but the module is not showing FY19. Instead it is showing FY20 & FY21. This is…
-
Lookup, Sum and Textlist Cheat Sheet
Hi all, During the last CPX in London, which was fun and insightful, came to my attention the fact that still now-a-days the most searched topic in Anaplan Community is "how to use Lookup and Sum". That is why I decided to share with you all this visual and brief explanation of how Lookup, Sum and Textlist work, I hope you…
-
1.6.3 Activity: Create Distribution Center Parameters Module issue
Hi While importing the data into the module the data is getting ignored instead of updating. I cannot clear this issue can u help regarding this. it is getting as ignoredmy mapping result no data
-
REV01 Price Book Module
Hi I am stuck here, How can I change the View to all items. Please guide. Thanks -Pooja
-
Applying time filter in page selector || count, sum etc. features in insight grid of worksheet.
Hi, Please help me out in following: 1) My module has time filter to show monthly value of desired year Additional to it, I also need to keep the time as a page selector in the top right of UX page . Can I apply similar time Filter to this time selector as well: can I restrict this time selector to show only the desired…
-
Differentiate if you are Importing into a Module or a List on the Actions system view
Create a new naming convention based off of the action being either an import to a Module or a List. EG. The L8 and 9 and 4th row would have List in the action section and the 3rd row would have Module in the name. This would be used to quickly reference things and make it easier to do research.
-
Line items missing in Waterfall
I have a module with 5 line items , A,B,C,D,E where C= A+B and E= C+D . Module is dimensioned by 3 lists L1, L2 and L3. All the list have multiple levels and lowest level is used. a waterfall chart is published in classic UX with line items in rows and all the lists in Pages. In development environment its working fine…
-
Time - week ending
Hi, I have a module where teams are required to input weekly but at a specific schedule e.g. week ending 7th, 15th, 23rd, and last day of each month. Is it possible to configure this? Thanks
-
OEG Best Practice: Model cut-over checklist
Introduction There are many ways to go about building a new model or rebuilding an existing model. The most important piece is the proper transition and cut-over. This checklist is a starting point to help you begin gathering all impacts building or rebuilding a model will have on the Connected Planning Ecosystem within…
-
Parent and Ratio
Hi, I need a ratio along a list called 'P&L' I made 2 line items : * MyRef = PARENT(ITEM('P&L')) * ratio = Budget N/ Budget N[LOOKUP: MyRef] MyRef give the real parent of the P&L list. Everythings seems OK here. Ratio give zero (!) which is wrong by the way the forumula Budget N[LOOKUP: MyRef] gives 0 also How can i bring…
-
Problems with Anaplan
Hello! I ran into a problem when passing the final exam in the Anaplan professional model builder program. I managed to do 6 questions and the 6th question was related to the data of my model. I opened the Anaplan website and started to open my model, and my website stopped working. All other sites were working and the…
-
why isn't CurrentUser a command
Why oh Why can't we have a currentuser() command. I have spent 9 hours (and failed) trying to develop a filter module just to hide people who are not the current user from a grid on a New UX page. It should be simple, IF dataModule.mailaddress = current user() THEN TRUE ELSE FALSE
-
how to create boolean boxes for user to manually to check on
Hi, I have a list of opportunities and would like to create a Boolean column for user to manually check on. I would then like to filter the list where all the opportunities are being checked off (Basically to filter the list where boolean = true) It would be best if this can be done in the NUX where the user can check on…
-
Bulk copy action
I am having one requirenent where i need to copy data between versions of one department and one product combination data ..how can i achieve that
-
IF statement help
Hi, I need some help with my formula - separately they are fine, but it doesn't quite work when I combine them together. In the consol I had initially just combined the formulas in A, B & C but it did not work so I then changed the formula slightly (see below). What should the consol formula be? Thanks AIF Line item A = X…
-
Variation Column that results "%" or "pts" in the same cell depending the account selected
Hello Everyone I'm trying to find a creative way to report the line items in rows and columns with amounts, variance $ and variance %/pts (the last in the same cell). In the screenshots below is the ideal formatting. Unfortunately Anaplan allow me to use only one Line Item, so I cannot create customized columns and be…
-
Pulling in data from a monthly module into a daily module
Hi, I'm trying to write a formula in a module that is time dimensioned as Daily, but the module I'm pulling the data from is monthly. How can I get data to come in. Basically I'm trying to break down the monthly information into daily. I do not believe a subsidiary view will work. Thank you
-
Customer to Distribution Center Mapping
Hello, I need to map specific customers to local DCs in a region. Rather than a 1-to-1 relationship, each customer could be serviced by multiple DCs. A) I've created a Customer Forecast module that contains customer demand data by customer, product, week. B) I need a mapping module that allows the end-user to make local DC…
-
Dynamic User List
Hey, I am creating a dynamic user list, wherein I need users with a specific designation (A). Now i created a module, applied a filter and filtered all users with designation A which is populated into my list 'Users with A' however when a user who is updated into the list ('Users with A') but later is changed from…
-
List Subsets vs LISS
I am new user trying to optimize mapping a model to avoid the issue with multiple IF/THEN formulas described in the following link. I have been trying to map my model using list subsets, but found the article deals with line item subsets "LISS". I would like to understand if this methodology based on "LISS" is also…
-
Decimal places default value to be 2 instead of 0
By default, when changing number to have decimal places, the number of places is 0. After finishing L1 model building course, I realized that most of the time the number of digital places is changes to 2, so I suggest it would be the default value for that action.
-
Calculation Query
HI. I'm struggling to understand why I am getting a zero answer on my pension row. Please see June 21 as an example.
-
Looking for a neat way to create a histogram in Anaplan
I am currently looking for a way to create a histogram out of a lot of simulated data I have created. Basically the application runs a full Monte Carlo Simulation and I would like to present a histogram of the Results. I have those results in a module with the "Simulations" list (lets assume it is all in one line item).…
-
Data Check
Hi, Is there a way in Anaplan to check if the list member has data in any module we have ? Thanks, Tom
-
INV04 Distribution Center Capacity Model: Beginning Inventory
Hi All, For some reason my Total Beginning Inventory in INV04 Distribution Center Capacity values don't look right. You can see my formula in the image below. It's basically saying my total beginning inventory is 137% of my distribution center capacity... Yet if I go to my DAT01 Beginning Inventory module, I can see that…
-
Build a model
I want to build a view to see sales for the year 2020 using products and customers dimensionality. Customers are spilt as active and inactive customer. Any suggestions for it??
-
Formula that will allow me to divide a child by the parent
Hi, Need help creating a formula that will divide a child in a list by the parent. screen shot of the formula I have Looking to take the Amt from both Direct & ISO and divide them by the All BU parent from another module in their specific columns.