-
Breakback for line items with Boolean format
As a model developer, I want to have option to set Breakback for Boolean input line items. This would be great especially for filters, using multi-level filters based on one Boolean line item can become easier. It should work if summary is set as "Any" or "All", and Breakback is ON for the line item, then clicking on…
-
Drilldown highlights relevant logic string
When a user uses the drilldown feature it would be awesome if the platform highlighted the particular logic string that was being applied within the formula to determine the final result. This would be helpful to parse long, complex formulas with many possible results. For instance, sometimes formulas have many IF a THEN b…
-
Lists and Roll-ups in New Modeling Experience
I love the new Model Experience, but I miss the classic model experience in terms of viewing Lists and Modules on the same page. It would be great if we could add the Lists and Roll-ups functionality in the new Modeling Experience. As a model builder, we could see the Lists and Modules on the page together as we had in the…
-
Need export "tab" vs. copy/paste
A csv export of the Import Tab in the actions Menu would be great
-
Allow a Process Action to have other Process Actions within it
I have a 26 step process in my Model (Process A). I have created a new, 31 step, process (Process B) . I have just realized that I would like the user to always run Process A after they run Process B. Currently this now means editing Process B and individually adding all 26 steps that are in Process A. Request: Allow the…
-
Provide the ability to filter+sort modules in the Modules in particular in the "Applies too" column
In short the title explains the proposed improvement. When you have larger models or multiple MB working on a model, giving the ability to quickly find and sort makes finding other places that someone is using the module to complete significantly easier and quicker so you don't duplicate work, can reference other modules…
-
New Model Experience - Formula Editor Function Tool-Tip
To further enhance the modeling experience, particularly for new modelers, having a hovering tool tip when typing parameters within a function would be useful. It could be structured such that after typing the start of any function, a hovering display lists the required/optional parameters needed. As an example, typing…
-
ITEM function cannot be used on composite lists with Summary of "Formula"
To reproduce: 1. Create a parent list and a composite child list. 2. Create a module with 1 line item with formula "ITEM(Child List)" and list formatted to "Child List". Applies To should be "Child List". 3. Change Summary to "Formula", the following error is shown: The formula for 'mod1'.'item1' is invalid: 'item1' =…
-
Ability to Turn Show Users Off at Line item level
If a line item is formatted on USERS, end user should not be able to see any other USER but himself in the dropdown and they should see only one name in the dropdown. Admins on the other hand should be able to see all. Hence the idea of Show Users: off at Line item level even if the module is not dimensioned by USERS. As…
-
Ability to exclude zero values from AVERAGE calculation
A common requirement we see on customer implementations is to be able to calculate the average of a set of values but exclude zero values. For example if we have the following set of values (10,0,0,8,0), the average excluding zeros would be (10+8)/2 = 9. The current AVERAGE function cannot exclude zeroes and so gives an…
-
Validation Button in Formula Editor
I would like to request validation functionality be added to the formula editor in Anaplan. On large models if a formula is entered incorrectly you can wait 8, 10, 12 minutes for Anaplan to process the incorrect formula. I have seen other application in this space have a validation button for formulas which allow you to…
-
MAX() and MIN () functions over time periods
Currently you can compare time periods using operators '=', '>' and '<' which is great and very useful. But when it comes to comparing more than two dates, it becomes a nightmare to find a MAX or MIN. Unlike with number or dates, you either have to go through countless IF THEN ELSE cases which is probably impractical or…
-
Add Versions as a native option for a line item/property format.
Description of the enhancement required: Version as a format An example of the enhancement: When uploading a planning file (budget, Q1 forecast, Q2 forecast) from excel, a number of identifiers for my transactions are uploaded as text and later on in the transactions module turned into line items based on a list so I can…
-
modules width adjustment
The module name will be cut off, so please be able to adjust the width of the column.
-
Model Optimising and Housekeeping
I'd like to have new features in Anaplan where it will check your whole model and return the following: * Module/Lists which are not references in actions/dashboards and therefore can be removed without impact * Line items which are duplicated in other modules and are using the same dimensions (therefore duplicated can be…
-
History on Formula Changes
Similar to Cell or Module history, there should be an option to get on demand history on formula changes. An option in blueprint mode to select any line item formula and get history option should be added. This will be helpful to track formula change in multiple model builder environments.
-
Include Formula Change Detail in Model History
Currently the model history process only captures that a line item was edited but it doesn't specify if it was a formula change, applies to, etc... and it doesn't include what the formula is/was. This came up recently in trying to research what had happened with a formula that had previously been updated and it's otherwise…
-
Allow for 'Invalid' formulas during model changes
When model building often we get requirements that require changing the dimensions of a line item / changing hierarchy levels etc. Basically things that will break existing formulas. To make these changes to an existing model I'll laboriously go about copying formulas that will break somewhere else, carefully making a note…
-
Built in notepad/clipboard
Hi Anaplanners, This time i am coming with an idea of having a kind of manageable clipboard/notepad built into the development UI. Performing development work i usually have some additional tools like notepad or excel opened on side to able to store formulas or mappings that i want to use in next few mins (example is a…
-
Time Subsets
I would like to see shorter time periods that we could control for example rolling 90 days, 16 weeks etc. Realizing there would need to be some sort of trigger of control set a start point. A potential user story I need to be able to solve is: I plan by month but need a 90 day outlook As part of that 90 day outlook I need…
-
Remember formula bar settings in new modelling experience
It'd be great if Anaplan could remember formula bar preferences either globally at an account level, or by workspace. At the moment, you will perhaps prefer to set the formula bar to the side view, with a specific width, and when re-opening a new module it will be reset to below the data and at default height. This means,…
-
Two Ratio summary - Different for Line items and Time.
Hi Team, Can we have to different Ratio summary for both line items and time. it will be helpful in few scenarios where we have to calculate ratios have to be calculated differently for line items and time. Thanks, Manjunath
-
Show Precedent Line Items
Excel has a great feature that shows dependent and precedent cells for formulae. For those that do not know, here is a screenshot of trace precedents in action: The blue arrow is indicating that Profit is dependent on Costs and Revenue. This is a great visual way to show how cells affect one another. Whilst Anaplan…
-
Number Formatting Precision / Stop dividing by 1000
I would like to propose a feature to instead of dividing by 1,000 to show items in thousands or 1,000,000 to show numbers in millions, that this is handled by the number formatting. This is a little used feature in excel where you can apply a format to a cell with the value $32,500 to display as $32.5. In this case the…
-
Time Subsets
We would like the ability to create time subsets for more granular time ranges (days, weeks, months), that may not match the current model Time Scale of Years, Quarters, etc.
-
Formula Editor with AI suggestions
As a SA, when we perform the model review, one of the most common issues are badly written formula. MAT analysis does provide a list of potential issues. It would be nice to add another button in addition to apply as Suggest, so it can warn the users when they try to create complex formula. Even better, given the vast…
-
Make the 'Referenced By' section of a Module Blueprint CLICKABLE
I want to be able to do the following: * Open a Module in Blueprint view * Scroll to the right to see the 'Referenced By' field of a Line Item * CLICK on this field and have one of two things happen:* If there is only one Line Item in the 'Reference By' the module with that Line Item opens (in Blueprint Mode) and (bonus…
-
number settings
Currently number settings can be done only at Line item level. It is cumbersome to repeat number settings across all lines in the modules in a model. Like Time and Version settings, can we have the option to set up Default Number Settings at a model level. Similarly, Rounding of numbers can be set up a default across the…
-
Allow for Copy/Paste of 'Reverenced By' to work in 'Model Search'
The new 'Model Search' is awesome! I use it all the time! I have noticed that it cannot handle a few search prompts. One of them is if the user pastes a full reference for a Line Item. An example might be 'CALC Store O4 Month Results'.Store Hours Threshold Pasting this in Model Search produces no hits. But the ideal result…
-
Increase 1 million list item limit for Order list action
Requesting to increase the limit of 1 million list item count for Order list action. Currently we will get the following error when list item is over 1 million: Cannot Run ActionThe number of items in the list (1000001) exceeds the maximum allowed (1000000)