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),…
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". Th…
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
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 . …
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 Modul…
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…
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
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…
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 see…
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 opene…
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 …
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 (Basi…
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…
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 i…
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 …
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 co…
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…
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…
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 t…
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 histogr…
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 …
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??
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…
Drill downs in Anaplan Modules should have a feature for checking what each part of the formula written does. For example if there is a If condition with a nested loop with multiple formulas and condi…
As we put headings as empty modules, these then appear on the model map. Could we not include zero cell modules on the model map, or give the builder the ability to exclude.
Hey Team, I am facing this issue on MAILTO. I tried getting it in two ways: - Option 1: - Used MAILTO functionality MAILTO(u, v, w, x, y, z) Result from triggering this option from the backend and fro…
