-
Ability to enter decimals without leading zeros via new UX forms
When we are using the forms in the new UX to create list items, the form with a number formatted line item is not letting the user enter decimal numbers without leading zeros ".05". When entering the number directly into the cell, it accepts it but when using the form, it gives an error saying it is not a valid number.…
-
Ability to move to different Workspace from the model itself
Current State Scenario: If you are working on a model and you wish to move to another model in different workspace you have to go back to Home screen then go to Manage Models-> Select Workspace ->Select Model Idea: From the current model we hit Manage Models->Select Workspace-> Select Model. This eliminates the need to go…
-
Conditional Formatting for Swtiched Over Cells
Using Native Switchover functionality when the forecast data gets overriden by the Actuals can we have a color code functionality which will highlight Actual Data in Forecast version. As of now it is just editable vs not editable.
-
Set the Export File Name at the time of Export
Hi when running a Data Export I would like to be able to choose what the file name should be when exporting the file via a prompt. In an ideal world I would like to be able to decide on a prefix and suffix for the file name. With one of the options either being the date/time or the value I set in a module. One of my…
-
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…
-
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…
-
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…
-
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 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.
-
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.
-
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…
-
List subset from formula
I'd love to have the ability to create a list subset from a formula. That would give a great way to pre-filter and limit sparsity in modules.
-
Enter Saved View on Saved View Creation/Save
When creating saved views, it would be great if Anaplan enters the saved view immediately after creation. Currently, anaplan returns to the default view of the module. This can be a bit annoying if you need to make a quick change to the view, such as adding a filter or showing/hiding columns.
-
Reorder button in Manage Views
As a model builder I would like to have the "Reorder" button in the "Manage Views" section of a module so that I can re-arrange my views quickly and easily. On big models with many views this could be a bit tricky. However, I agree that if builders keep on top of it as views are created and use naming conventions, this…