-
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…
-
Disallow un-assigning items using the 'Assign' action
Description of the enhancement required: Disallow un-assigning items using the 'Assign' action. There's a left-arrow in the assign action that will delete an existing list item. It would be great to have an option to disable that arrow, or disable removing existing items this way. An example of the enhancement: Admins…
-
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.
-
Copy Across and Down on right click of an inputable cell
Currently option for an inputable cell when right click are copy, hide, breakback, sort etc. It would be nice to have the option of Copy Across and Down in dashboards. It is already available on the edit option of the module.
-
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…
-
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)
-
Improved History Granularity in History Report
Description of the enhancement requested: When the client exports the history they want to see the details on who changed the Formula, as well as having an ability to filter out the needed modules, lines, etc. The output is there but they want to be able to filter it online as it is close to impossible to do in…
-
Quick Summarise Data
One question I always ask myself when exporting data from Anaplan into Excel for further analysis is why am I feeling the need to do this and what improvements could Anaplan make to negate the need in some instances to export data to excel. I believe adding some fairly simple functionality to quickly summarise data by a…
-
New Formula Editor - Positioning and Default Setting
For the New Formula Editor is it possible to: 1. Be able to dock it at the top and left of the screen as well as the bottom \ right 2. Set a default so that each time you expand into the new editor box it opens to the left\right\top\bottom depending on your setting, or if a setting is not possible then have it default to…
-
Allow the Modules List to be searched with fuzzy logic, the saem as the Model Search function
The new fuzzy search method available in Model Search is excellent! I use it to rapidly jump to another module. But we still must use the modules tab to copy modules. I now find myself trying to use fuzzy logic when using search in the modules tab. Could we please get this implemented here?