
Modeling
Modeling
Discussion List
- Hello, I'm having an issue in which a sum of rounded items is still showing some unexpected decimals. See screenshot below. Is there a workaround for this other than using formula as the summary metho…
- Hi, I have a error message that keeps on popping up when I'm trying to create a formula. Please advice. Image is attached. Thank you
- Hi there, Module 1 has a model calendar, and module 2 doesn't use it. The model calendar has two future years & past years. I wanted to summarize the boolean of Module 1 in Module 2. I didn't get the …
- Hi Everyone, I was wondering if anyone knows or has experience creating duplicates of an Input Row and all of it's associated components based on a quantity line item? For example, if I wanted to crea…
- Connect or Python Summary As a supply chain Anaplan data integration modeler, you might be asked by your business partner to display actuals for elapsed periods and forecasts for unelapsed periods. If…
- Hi, I have the following module: Lists: E1 Employee Time: Month Versions: - Line Item: Salary I need a pivot with the employees as rows and month by column. All fine uptil now. But then I would like t…
- Hello, We have a dashboard which features a smart filter for sales rep. When you select a name from the smart filter, the corresponding grid's selector only holds the accounts owned by that rep. This …
- It could be great if we could see in a tree view the lists and their attached subsets. It is particularly useful when exploring a model previously created by someone else.
- Rather than functioning towards excel for the previous year / excluded year data to save for future. There must be a process which will archive the data as soon as year got changed in TIME settings (w…
- Anaplan must offer a functionality which auto suggest (time and again) what are the least referred lines items / lists / modules from model optimization point of view. This will help dev team to optim…
- Hi, Would like to know how to create a Formula with the following structure for a Line Item (1). Closing Balance of Line Item (2) as of the end of the month, and this will show/happen only on the 10th…
- I'm looking to ensure my modules are as small as possible. In addition to other optimizations I would like to ensure every list item that is contained in some of my bigger reporting modules is needed.…
- I am at the end of Level 2 Sprint 1. I am going through the checklist to make sure everything was completed. When I got to DAT03 I noticed there is no data in any of the cells. When I did the first im…
- HI, Have a module with assets and time dimension, some of the assets starts from the middle of the year. when on selection of total assets, The "No of payments" lineitem not showing sequential numbers…
- I have a line item that needs to reference one of the list items instead of a line item. What does this mean? I have a list of staffing types that use a model configuration to calculate based on what …
- hi, have 3 lineitem, a, b,c wherein c= a+b, a = previous(c), b= a*rate of interest, But, however, getting a circular reference when writing a formula in the lineitem "b". Below is the screenshot of th…
- Hi, I created a LISS for my P&L but when I then use that LISS as a dimension for a reporting module it changes completely - see attachment for example. I've tried re-creating the module as well as ano…
- Hi Friends, I am not able to understand the exact requirement of the question. What is the total sales target for the medium sales account in Canada?
- Sometimes there is a necessity to be able to update the Subset from the User interface. For example when you add a new Equipment and you are using a list of subsets to limit the size and selections. I…
- Hi, I'm stuck on a sum select formula ?? Circuit Pull.Project[SELECT:Projects.X, SUM: Circuit Pull.Range] ?? Essentially what I'm looking for is to hard code a specific project below, project 2 but I …
- How can we link these EMP02 and REP04 modules to get total car costs by the region and role. When I am using formula i.e car costs = emp02 .carcosts[lookup: sys08.region, lookup.sys08.role] it is thr…
- Hi Anaplan, It would be great if the NEW UX had the capability to export boards as PDFs for reporting. Many customer are asking for this as they have previously created many reports using this in the …
- I have a view published with list-1 in rows list-2 in columns list-3 in pages list-4 in pages. The dropdown for list-4 is dependent on item selection from list-3 and vice versa. Filters are created fo…
- Hi, How would I create a formula that would give me the number of days in a given month?
- I have a module with a list-1 in rows list-2 in columns list-3 in pages list-4 in pages. The dropdown for list-4 is dependent on item selection from list-3 and vice versa. Filters are created for that…
- Hi, I need some assistance. I have created a dashboard in the NUX with 2 separate modules. I've created a Product Type Selector (Product Type A, B ...All Product Types) which then filters on the modul…
- Hi, I have a line item Start and End that has a list of 1-5 as shown on the screenshot below. In the example below for item 1, I have selected start and end date of Jan 19- Mar 19, in item 2 I have se…
- Hi, Please help how can I get the total value of another line item to the other. Pls see attached screenshot where I tried to use lookup of the parent hierarchy to get the total value but it is not pi…