Modeling

Need formula help to calculate YEARTODATE -1
Hi, I have a need to calculate YTD Actuals but the amount should show the sum of values from start month (Jan 19) to One month prior to the current period i.e (July 19). The current formula I have is this: YEARTODATE('P&L by Cost Center'.Amount Adj[LOOKUP: Version Selector.Actuals]) I need to pull YEARTODATE just until end…
Group by Property
Hi, I wonder how you can group-by list properties. Specifically, as in the attached file, I would like to have figures by properties (category: Fruit/Vegetable) as shown as "Desired Result" Thankyou in advance.. Greg
Formulas Not Adhering to Subset Formatting
I believe that I have found a bug, but wanted to check this by the Community to see if I'm missing something or if there are some additional creative workarounds that we could employ in the future. I've created a simple illustration of what we are encountering for the screenshots below, but what we are doing in reality is…
Allow marking Line Items subsets as "Production data"
Currently line item subsets are structural data and the only way to make changes to them is in the dev model then syncing those changes to prod. I would like to be able to mark a line item subset as production data so I am able to add and remove line items to it in my production model.
Removing Duplicates with custom conditions
Hi I have a requirement to delete duplicates with some custom conditions. Consider the Element "occurrence" in below image for your reference, I need a formula to automate this boolean element. Conditions are as follows 1.First two elements with first data "11" has Second Data "0" and "1" , In such a case , we need to…
299 Model build query regarding subsets
My subsets are not working in 299 modelbuild for Cost Centers . I am unable to get heirarchy in modules. Anyone help me out . That central subset i See the hierarchy it is emptyn null heirarchy
Hierarchical structures from a customer provided list
we all understand the traditional way of building a hierarchy normally following a top down approach. We sit with a challenge requiring that the hierarchy needed to build up from the bottom up using a lowest level reference code. As per the attached picture. Each lowest level will have a specific code identifying where it…
Question on Maturing inventory
Hi Everyone, i’m hoping you might be able to help me, I’m looking to build a model which takes an inventory with a start date and then shows when it comes of age e.g. beef that needs hung for 28 days, or wine that needs stored for a couple of years. I’d know the current demand but I’m not sure how Or if I can get the…
Data-Driven Forecasting for the Holidays
During the holiday season, the ability to analyze and react to data effectively can be the deciding factor between having your shelves stocked or scrambling with inventory transfer issues. Historic data can provide the basis for true statistical forecasting, accounting for seasonality, and other retail trends. Cleansing…
Anaplan Software Pricing details for 50-100 Users
Hi All, I would like to know about the Anaplan software pricing details for 50-100 users and also pricing details of the different model sizes? Kindly let me know the details of above. Thanks Sasikanth
Sychronizing Line Items
Hi All, I am using Line item subsets to create a series of P&L statements at varying levels of detail. Is it possible to synchronise these line items across modules when publishing to a dashboard? In the dashboard it is possible to assign parent items to line items which follow a simple sum but they are restricted to items…
Use Time Ranges in formulas: Make the Time Range a named member in the Time Dimension
If Time Ranges were true named member in the TIME dimensions we could easily control formulas and filters based on a time range. It would also allow for YoY changes in formulas to be maintained easily w/o having to create multiple line items. Many companies need to save off older versions for compliance reasons. Adding the…
Shared Node(Similar child in Anaplan)
Hi , I have two List List1 and List 2, List1 is a parent list of List 2 having 4 members as: Parent1 Parent2 Parent3 Parent4 Is it possible to add similar children(replicate same child) in all the Parent1 to Parent4. i,e Parent1 having child as Child1,Child2 & Child3 Parent2 also has child as Child1,Child2 & Child3 As per…
Hierarchy change
Hi All, Wanted to ask for a best solution of this question if possible. I have a process hierarchy which consists of 3 levels, and I need to extend it by adding 2 more levels between levels 1 and 2 (so whatever is on Level 3 now should go to level 5, and whatever is on Level 2 will be transferred to Level 4). What is the…
Stopped Data using time period
Hi, Anaplanner how to enter data and stop using time selection ?,, i have 2 time selection, start and end start for when data come and end for when data stopped
Identifying the max value for a specific field
Hi, i do like a dilemma it seems... I have a list with 2 fields (well lots but 2 that matter) Bvfsku and Vintage I want to add a field that indicates the one that has the latest vintage (2018 in this example) So a boolean or a number field that is set to TRUE or 1 if the Vintage is the latest year.... How can i do that…
Understand why a formula in the List Property is not working?
Hello, I have a list property that has a formula in it that was working and pulling data correctly. But today, it is not pulling data and I am not able to identify the root cause. Here is the screen shot of the list property formula: Here is the module where the formula is pulling the data from: Your help in guiding me in…
Line Charts should display trailing zeros
Model users are confused by line charts which stop along the x-axis. They need to be trained or instructed that trailing zeros in line charts are not displayed. Please update Line Charts to include trailing zeros.
Open Dashboard and different target dashboards based on a page selector
I want to use the "Open Dashboard and different target dashboards" feature based on a list property linked to a page selector I published in a dashboard, but it doesn't work. It works if I publish the whole module (not only the page selector). Is there a way to make it work publishing only the page selector? Thank you.
LOOKUP function Blank result
Hello everyone, I am currently working on a model where i am using some data i imported in formulas to create some relevant data for a YTD model. I am trying to implement the following excel formula : IFERROR(VLOOKUP(A2;'TCD CRISTALLINE'!H:I;2;0);""). So in the first part of the implementation i started off by trying to…
Trying to map data to a line item from a list
Hi, I'm creating an upload into a list. I've then created a module that looks back and returns the values from the list. I need to be able to map certain factories to certain line items. So if my factory is 1 then i need the line item to be returns from another module with a certain heading. The reason I can't use a…
spread of value on identical children
Hi, I have two modules, using two different list List1 and List2. List 1 module has a member FM and a line item amount value as 100. List 2 module has members FM1, FM2, FM3 & FM4. I want to spread FM value 100 from module 1 in module 2 having total four member starting with FM as 100(value)/4(count of FMnodes) = 25 each.…
How to add time period selection option in process while importing file
Hi, How to add time period selection option in process while importing file. Attached the screen shot for the reference. Thanks Usha
How to display date as Week number?
Hi experts, Could someone give me an advise for showing date as active week code? In my model, standard week is converted to active week and requested shipping date. Then, my client argues that we should export Demand forecast data in active week style (e.g. 202023 ). This is what is exported. Is there any solution for…
Unable to copy and paste value for line item with list subset type
Hi, I have a list and subset of it. I create a module, add line item, set its type to the subset list I notice that i can't copy and paste the value of that line item from one row to another, it can't be done by import action too, but if select it manually, then it is fine. Is it a known limitation for list subset? or is…
fetching Month from a Date we give
Hi Team, I have a use case where I need to find which month does a given date belong to. Could you please help me Thanks & Regards Prashanth Akula
More than one value for non-numeric cell
Hello everyone, I am having some trouble with the model i am currently trying to build, i am trying to import, into a module i created, a file containing a table (in an CSV format of course) with two columns : The reference and the description of those references, so i created two line items (reference, and model…
New Item addition for List(not numbered list)
Hi, Can I add create new item button for a List(not a numbered list). Regards Madhu
Lists as page selectors
Hi, Is it possible to create dependent page selectors when more than one list is published as a page selector? I have a module that forecasts demand for SKUS in different country. Currently when the user selects the country the next selection is SKU but the SKU dropdown shows SKUs for all countries. I created a filer…
Best approach on creating a comment section in a Forecast
Hi, I was wondering if it's possible or the best approach on creating a comment section. I tried creating a text line item but it seems to have some flaw to it. I can't make any edit on the Actual, I can only write comment on the forecast, etc. Is there a better approach to this? I included a screen shot to give you an…

Modeling

Discussion List