-
Creating views/"child-modules" with a calculation layer?
I have a master warehouse budget model which has several modules but let's consider the following modules for example: Shipments, Freight Charges, Headcount, Inventory etc. All are inter-linked by formulas and the setup is complete. I now wish to create child warehouse budgets with the entire set of modules as the master…
-
The Truth about Sparsity
In case you missed these from the home page: https://community.anaplan.com/t5/Blog/The-Truth-About-Sparsity-Part-1/ba-p/44493 https://community.anaplan.com/t5/Blog/The-Truth-About-Sparsity-Part-2/ba-p/44736 David
-
Formula
Hi Experts, I have a requirement and i am confusing how to resolve this. First Module Row Axis:Product Column Axis:Line Items Second Module Row Axis:Flat Product Column Axis:Line Items Both Product and Flat Product have same members. I am trying to multiply First Module line item * Second Module line item. How to write…
-
data import query
Hi @DavidSmith , I had one more query . For instance, A module consists of 6 line items, Is it possible to importing the data into module for each line item separately( as of new set of data into each line item), If possible then importing of data is of same way of uploading.
-
Selecting Time averages
Hi, How to select the yearly average value of a line item from a module that is dimensioned by time (monthly), for the current year, in another module that is not dimensioned by time? Please note, I wish to make the formula dynamic and not use static values like TIME.FY19 I have a "Shipments" module that is having monthly…
-
selecting TIME period
Hi, How to select the yearly average value of a line item from a module that is dimensioned by time (monthly), for the current year, in another module that is not dimensioned by time? Please note, I wish to make the formula dynamic and not use static values like TIME.FY19 I have a "Shipments" module that is having monthly…
-
dynamic cell access query
If I am using dynamic cell access to some line items by using write access drivers and read access drivers then quaterly data not displaying, If I am removing it , then it is like usually displaying normally quaterly data. Can anyone explain what is the reason behind it.
-
sequential numbering in line item
Hi, I would like to know how can we create a sequential numbering in a line item. I saw some post where they use RANK but it does not fit the requirement needed. In the module attached, I have a line item Transaction number where I want to show automatic numbering (1 - 100 for example) of the number of transactions. This…
-
How to select one line in a grid and refresh another grid
Hi, we have a dashboard which contains 2 grids. The first grid is applied to a list. The second grid is showing items based on the selection of the first grid and applied to another list. We need to select one line in the first grid, and let the dashboard auto-refresh the second grid based on what selection the user makes.…
-
Issue With Percentage Data
Hello, Specifically I am unable to enter values (format is Number with Percentage) 3, 6, 9 for a line item. Except the above 3 numbers I am able to enter other numbers. While entering 3, 6, & 9 in the cell, it is getting automatically replaced with 2, 5, & 8 respectively. And this issue I am facing with Microsoft Edge with…
-
How to create multiple list items from a module
Hi there, Just wanted to know is there any way that I can create multiple entries by using a module? ( by using list we can create multiple list items by using + sign) Requirement is, when we select a particular D6 department by using a page selector of Departments(they should be created under a selected D6(We have D1 to…
-
102 certification Missing model
Hi, I may have accidentally deleted the 102 certification model and now i don't know how to retrieve it? Is there a way to put it back as active model in my account? Thanks
-
Unable to create button to add new entries into line item by using action
Hi, I want to create a button in dashboard for adding new entries to line items. see here, here i want to add new entries such as i want to add '9' next to '8' as ways for i want to delete '7'. For this i want button to this action dashboard. So while creating action. I am unable to find this(Capex Inputs) in action…
-
Anaplan connect with batch file model building import question
When importing data from anaplan connect with a batch file what is the best practice to automate the data through a batch file. Is the best model building practice to create a list for the data to flow through the list. Is it possible to have the data go directly through a module? Are there row limits when having the data…
-
finditem in list with parent as a lineitem in module
Hi, I have this module of list Quota Types and I want to find the items Quota Types list and display them in Secondary of Secondary Quota Name line item below, who has a parent of Secondary Quota Name I'd love some help please! Thanks 🙂 Amanda
-
Numbered Lists renumbering
Hello, Is there a way to reset the number generated in a numbered list? Also, is there a way that we can sort a list in alphabetical order after import? Thank you!
-
Introduction to Modeling UX Headcount
Hi, I'm working on the UX section of the introduction to modeling, and I cannot get the headcount module to populate with data when it's on the dashboard. Interestingly, there's data in the module itself and when I publish other modules to the dashboard they also show data. What could I be doing wrong? Thanks for your help…
-
Refresh of the list not happening after 'Delete List Item Action' on Dashboard
Hi I have a list which has records I published it to the dashboard as a page selector on the dashboard. I created a delete action to delete an item in the list based on drop down selection. Now after making delete selection in the delete Record and clicking the 'Delete the record' button. After the action has been run it…
-
formula
I have the problem .. i have a list on left and i have the formula like the picture .. half the list using formula and half again using formula but null value . how work for the problem?
-
Average of Daily Data
I am building a new model and have daily data. Our data is only for weekdays though. So when I use the average Sum method Anaplan averages in a zero for Saturday and Sunday which is obviously not what is required. Seems like there should be an option in Model Settings/Time to allow me to define what a week is but there is…
-
Invalid Parent While Importing in List
Hi, I am trying to import a product list which is a numbered list form another model say ICM. But while trying to import it,it shows the invalid parent entry.However the list is getting rolledup to the correct parent. Screenshot attached.
-
Filtering only summary items
Hi, I have a list that is used as rows in a module and the list has a parent hierarchy. I would like to filter out only the summary items when publishing to a dashboard, but can't seem to find a way to do that. What I tried to do is just set a value of 1 for the list items and then filter everything that's greater than 1,…
-
List
* I want to ask about List. i want to take code on Account L0 Flat List to Account L0 . Account L0 FLat is list format .. *
-
FINDITEM formula
Hi all, I have a list named "TAT Hours" and a line item "TOTAL HOURS" that is in number format. I used FINDITEM formula to get the number of hours (TAT Hours) in the list, here is the formula: FINDITEM(TAT Hours, TEXT(IF TOTAL HOURS <= VALUE(NAME(TAT Type.Min Hours[LOOKUP: 'TAT Type1'])) THEN VALUE(NAME(TAT Type.Min…
-
Optimizer Overview - Not Showing Correct/Optimized Results
Hi, I have a simple LP problem where in I need to check how many Units of Big Products and Small Products can I make in order to maximize my profits keeping constraints in mind. Objective : Units to Make for Big and Small Products Inputs: 1. Manpower for Big is 6 Hours and for Small it is 9 hours 2. Raw Materials is 1 Bag…
-
Line Item Subset for Text Formatted line item
Is there a workaround for selecting a non-number line item in a Line item Subset? I've created a filter for increasing and decreasing the number of lines shown in a dashboard table using David Smith's outline in this…
-
Intermediate Model Building (OnDemand)
Am doing activity 20 scenario selection.How do i make the selection dynamic.this is how i mapped it.
-
Intermediate Model Building (OnDemand)
When i test for Brad Bonson i get CRE as well but looks like am only supposed to get CAE.Cannot figure out where i messed.
-
Dimesions
What is the difference between Built-in and Default Dimensions?
-
Section 12, Activity 17 - Ramp Line Item
Why is ramp format a number and not percentage?Am trying to appreciate the formula and output on this line item.