-
Ability to Comment Code
The ability to put comment blocks and indents within your formulas, so as to allow model builders to better document and format their code within the models for readability and understanding purposes. This will help align Anaplan's language back to the basic features all other development languages used in an enterprise…
-
Adjust Size of List Items in Columns
We have an option of adjusting our Row Size, this is useful when we don't want to show the dimension of the module. There are cases when we don't want to show Rows as well as Columns of the module like the typical 2-D/excel way of displaying things. Hence Proposing an idea of Having an ability to adjust the Size of the…
-
Click through Formula
Formulas should be clickable. Ex: If formula for one line item is as follows: Sales.Actuals When we hover over Sales or Actuals then it should become underlined and clicking on Sales should automatically open Sales module.
-
Group/Ungroup Hierachy Items in Module
Not sure if this has been posted earlier but it would be awesome if we have group/ungroup feature in Anaplan on dimensions within a module. Basically Tree View of Modules which will help in grouping & ungrouping of list items based on the parent nodes. This should be applied only if the list is in rows or columns
-
Summary of Visible Items Only
Note: please send Kudos to this post to get it on the roadmap. Please can either model builders or end users have the option to toggle the summary method used on lists where it is possible to view the total of visible items only. For example, consider a list Countries in a module with one line item, Revenue. Countries…
-
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…
-
Show Multiple Spaces in Module Names (Bug?)
Not sure if this is a bug, or just a weird feature. If you enter multiple spaces in a module name, Anaplan will trim to a single space when displaying the module in the modules panel. For instance 'Country P&L' becomes 'Country P&L'. This becomes an issue when using the search function to try and locate a module. The…
-
Subtotal in bottom right of Anaplan
Hi, I would like an enhancement made where, similar to Excel, when I highlight a series of cells with numbers in a column or row or both, I want a Total, Count, and Average to appear in the bottom right of Anaplan so that I can quickly look at measurements of the data I've selected in a module. Thanks,
-
Filter what appears in the dropdown for a list-formatted line item with a boolean
Current state Currently, you can filter a list using the "Selective access" and "Dependent" checkboxes when you go to the Format property of a line item, or you can create a list subset. It may happen that you want to have more control over what appears in the list than the checkboxes allow... but applying a subset comes…
-
Enhancement to RANK function when dealing with tied rankings
It would be really useful for certain cases if the RANK function could generate a sequential output when dealing with tied data. Currently, the RANK function can deal with tied entries in 4 ways, MAXIMUM, MINIMUM, AVERAGE and SEQUENTIAL and all handle tied data in a slightly different way but do not generate an output in…
-
Categorizing the content panel based on the Module Categories
I have always wondered what are the benefits of categorizing the functional areas of the modules. In content panel we only see functional areas and not the categorization. It would be great if this categorization can be applied to the content panel. This would help not only the admins but also the end users and I also…
-
Creating New Model with No Access to others by Default
When a new model is created why does Anaplan provide access to other users within that workspace by default. It would be great if this gets restricted to the user who creates the model and then users can be added incrementally.
-
Summary method shown when drilling down
I suggest a simple addition to the drill down feature that displays the summary method that was applied to the line item. This is because it is sometimes not readily apparent (especially to an end user) how a top level summation has been calculated.
-
Support of basic excel functions like RAND, RANDBETWEEN, RANDARRAY
It would be nice to have these Random number generating functions. These functions revery useful to generate some test and demo data, rather than inputting numbers and copy forward or importing from an excel. Can all be used for other purposes that I can not think of now.
-
'List Item' Scope on Formulae
Would it be possible to implement a 'List Item' scope similar to Version Scope against line item formulae within Anaplan. My thinking here would be to allow some list items to be driven by inputs, and other list items to be driven by a formula. This would be a huge enhancement, but in than vein I am unsure as to how…
-
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.
-
Filtering a list based on a property
When in a list grid view, enable a list to be filtered on a property. This is only possible by creating a module using the list and creating line item linked to properties.
-
Add Folders for Modules and Lists
Similar to the idea posted here, but with this idea could be a possible solution? * Add folders to object contents (e.g. module, list, and actions). * Allow the creation of sub-folders. It goes without saying, but this would really improve model organisation, especially for larger models. The functionality could be similar…
-
Add Sort Selected On Reorder Dialogue
Can a 'Sort Selected' group be added on the reorder dialogue, similar to the 'Sort All' group shown below. This would help with organisation in models, most notably where you want to order numbered modules, but only in a specific area of your module list. The group would have a similar function, but as indicated would only…
-
Improve List Item Deletion
Improve the list item deletion within Anaplan so that if a model builder selects 'Delete All' from the delete dialogue when there are vast numbers of list items the model builder is prevented. Doing so would prevent model and workspace lock ups. To explain this further: Consider a list with 1,000,000 items. If you attempt…
-
Option for setting standard totals positions on rows
Totals position on rows defaults to "after" for each new module. Would be good if one can set the default on model level.
-
List Inheritance
Where lists are in a hierarchy, it would be really helpful if Anaplan natively understood the concept of inheritance. Here's an example. Consider two lists in a hierarchy: * L1 Countries * L2 Cities L1 Countries is the parent to L2 Cities. Within an attributes module, each L1 Countries list item is assigned a currency.…
-
Add XOR formula
Title says it all, a XOR formula would be really helpful and reduce formula length when trying to test an exclusive or. For those unfamiliar, here is the logic table for XOR. It acts as an OR however if both inputs are TRUE, then XOR returns false.
-
Summary Method per List
In DISCO we create CAL modules that are purely for caulations and turn Summary Method to NONE. There are though many times where to be most efficient you may want to only have the Summary method apply to one list. e.g. you want it to SUM on product only because you can then use it in an Output module which doesn't need the…
-
Insert Line items – Format settings
The reason behind the ask is because Anaplan is not letting the model builder even to add dummy line items (Divider with None as a format) if the model exceeds the size as it takes the 'number' as default. I hope to resolve this concern, probably Anaplan can let the developer choose the format of the line item before…
-
IsLastOccurrence
We have Native IsFirstOccurrence functionality which helps us in a number of ways while modelling. I think having IsLastOccurrence will also be equally helpful in Anaplan.
-
Improved Formula Editor/Bar
If the following features could be added to the formula bar in Anaplan it would make model building and maintenance a lot easier! * Colour coded statements and keywords (e.g. IF THEN ELSE, line items, constants) * Ability to indent and enter new lines. Particularly useful for IF statements * Keyword autocompletion *…
-
Switch Statement Formula
Adding a switch statement formula to Anaplan to get rid of long nested IFs! This would assist in readability (and therefore maintenance) of complex formulae. Switch statements allow you to test a condition, and assign an outcome to each condition. For instance you may have want to test what mode of transport is being used:…
-
Deactivate Formula Scope if Versions = Not Applicable
Hi, In a module blueprint, there is a field called 'Formula Scope'. For modules where Versions = Not Applicable, using 'Formula Scope = Actual Version' or 'Formula Scope = Current Version' will nullify the calculation of any formula in a line item. This is potentially dangerous, because: 1. If there is a formula + Formula…
-
User List Top Level
The users' list should have a top-level for calculations. Currently, the users' list can't be used for inputting data as there is no top-level so errors occur when referenced by a line item without the user dimension.
