-
Planning functionality
Anaplan allows planning at different level of detail using its multi-level master data. Is there functionality like automatic aggregation/disaggregation? Is there data available over a time horizon?
-
List Item
I have a numbered list with (with 3 hierarchy levels) which is populated using data source nightly. However, User also requires the ability to manually add items to this numbered list at any of this 3 level with dummy name. Based on this dimension (numbered list) user will be planning and forecasting values. I want to get…
-
Employees per Team
Hello, I have this "Employee Profile" module with dimensions Time and Employee list as shown below: Immediate Superior Line item is a list-formatted line item, that uses also "Employee List" as format. Is it possible to make another module using this data, to show all employees reporting to each Immediate Superior every…
-
Line Item Subset Missing % Sign
Hello! I have created a variance analysis without using a version and instead using a line item subset. In the attached snapshot, Revenue, Gross Margin, and GM as a % of Revenue all belong to a P&L Line item subset and Actuals, Prior Year, and Versus Prior Year (VPY) are line items in the module. In the module in which…
-
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
-
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…
-
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
-
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…
-
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…
-
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…
-
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…
-
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…
-
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
-
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…