Modeling

Matching
Hi, Please see attachment Regards,
299 Case study enhancement
I am trying to create a line item and a notification where if the sales manager declines the sales rep input, the sales rep can reenter a value and the sales manager is notified.
Production Data Masking
Hi We copy the production model into our test workspaces, but as per policies we need to scramble/mask the data in test workspace How it can be done while copying the data ? or it has to be done manually in test work space by identifying the relevant data ? Any advise will help us greatly thank you
Formula Summary Method for List
Hi, I have module with two lists L6, Metrics List and one line item L6 List is parent child hierarchy list Metric List is flat list with one parent (Total Metrics) Source(Line Item): ITEM(L6) The Ask is, In Source(Line item) values are not getting populated at Total Metrics Level Thanks & Regards, Asha
Case Study 299 HR planning costs
So for the HR Planning Costs dashboard there is a module where you can input social security, pay raise % and pay raise date and that module affects the details of each employee module. Is there a way where the social security, pay raise % and pay raise date module does not affect every employee, whereas I can choose which…
Import file with several sheets
Hi, I have a module where I have a number of line items and two lists as dimension. One as rows and one as page selector. I want to build a function to export all data from that module, edit it in excel and then import the same file again, and hence get the values updated in Anaplan. Now to the issue: When the file is…
Display message on Period Level
Hi I have module which shows variance of data populated by month this module is published in the Dashboard. and a Text message in the dashboard is displayed "Having variance" or " No Variance".(This is a different module) which works fine based on data available or not. Problem here is, for example when 'FY17' or 'All…
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

Modeling

Discussion List