-
IRR - returning NaN
Hi, I have a module with below dimensions. I need to calculate IRR for additional planes. I have followed the suggestions and created a transaction module with the following dimensions (Schedule, Aircraft, Airlines, Time month scale, versions). It is not returning a valid result in below module. Any suggestions that would…
-
about date format
Hi, I'm trying to import date data. I failed importing as date format, so changed to text then succeeded.(below "week date") Next I'm thinking that changes to date format. So I tried using Mid function and Date function, but the value wasn't filled with cell. What should I do or is there good way to import date?? Best…
-
Summary Default to None for Numeric Line Items
Can the default Summary for numeric line items be None rather than Sum. This way it's a conscious action to turn the sum on, rather than a need to remember to turn them off. I know there's another post to have this an option that can be set by each module, which would be advanced, but I continue to hear about sums being…
-
The Anaplan Way Completion Certificate
Hi, Do we receive Completion Certificate for 'The Anaplan way " , if so where can I access it?
-
create list
Hi, I'm thinking 2 parent relationships(below photo) and I want to share information of the child element(people). Are there any ways? Best Regards,
-
Copy Dashboards - Same as Module
I would like the ability to copy a dashboard from the "Dashboards" area under Model Settings. This would provide more consistency to model builders. Right now, I have to open the dashboard and copy from the dashboard from the user dashboard menu, which isn't quite as intuitive.
-
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
-
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…