-
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…
-
Add option to search for data anywhere within the table of a module, not just the rows dimension
Pretty self-explanatory but I want the ability to search for data or text or part of a formula anywhere within a module, not just the rows column. Identical to what Excel does with ctrl+f.
-
Numbered lists to add display name by default
I think it would save a lot of time during initial model setup if the following actions happened when a model builder checks Numbered List within the general lists panel. * New property within checked list created called Display Name. * Display Name property format set to text. * (Potential) Set Display Name property…
-
Improve Keyboard Navigation
Similar to a post by AnaplanIdeas found here, it would be great if Anaplan had improved keyboard navigation. Specifically, if the following areas were navigable by keyboard: * Model settings pane * Lists panel * Modules panel Importantly, if users should be able enter elements using the enter key, rather than having to…
-
More Shortcuts
It would be great if Anaplan supported more shortcuts. In particular, shortcuts that would enable model builders to change the formats of line items instantly. E.g. if a model builder hits B over the format cell, it will instantly change to boolean. M for time period months, T for text. Shortcuts are extremely useful and…
-
Improve FINDITEM() when used with Time
Similar to improving imports with time periods (Idea Link), it would be great if the FINDITEM() formula was tweaked when working with Time, to make the formula return time periods for strings like Jan-20. Reason for asking (lifted from my previous post in the Idea Link): The standard excel format for Month-Year is MMM-YY.…
-
Move "Refresh" button from Edit Menu, onto Main Blueprint Toolbar
This is a quick one, but I was wondering if we could move the Refresh button out of the Edit Menu and into the main module blueprint toolbar? When I explain it to new folks, they always find it un-intuitive to have to open the Edit Menu, before they can Refresh.
-
Drill Down View Enhancements
Drill downs in Anaplan Modules should have a feature for checking what each part of the formula written does. For example if there is a If condition with a nested loop with multiple formulas and conditions in it, then there should be a provision to select what each condition does regardless of the condition being True or…
-
Ability to customize Dimensions for line item summaries
I would like the ability to customize the dimensions across which the automatic line item summary will apply. Currently, we can only specify Summary (for all selected dimensions) and Time Summary. This means that for multi-dimensional line items, if I need a summary over one dimension I am forced to summarize over all…
-
Line Item Format move Style format dialogue
When you click on the line item format I would like to be able to choose my style at this stage rather than having to scroll to the right to then change the style that is applicable to the line item.
-
Move multiple actions in a process at one time
When you add actions to a process they are added to the bottom on the list of the already existing actions. Whilst you can move a single action I would like to be able to select multiple actions and move them in a single action.
-
Ability to select multiple models to change the mode
Hi Anaplan, It would be great if we have a feature to select multiple models in the Manage Models page to change the mode at one go. For instance, if I want to archive 20 test models created by my team mates, then it would be easy if I have an option to click a Boolean to select the models and change the mode from Standard…
-
Allow un-balanced hierarchies on composite hierarchies for child hierarchies
As a model builder, I would like to be able to add "parent" elements into the child hierarchies (Level 2, 3, etc.). As for now, in a child hierarchy is allowed only to add leaves elements (elements without children) because as "parent" are allowed to be set only elements from the parent hierarchy. As for now, the unbalance…
-
update source model default
In the model settings -> Source Models you are able to edit a mapping and change the source to e.g. the production model rather then the development model. For some of our models we have recreated multiple development models (copy of production) this resulted that as source model there are a lot of non existing models…
-
Ability to drag and drop an Import action in a Process
Hi Team, It would be really good if we have a Drag and Drop feature of an Import action (in addition to Up and Down arrows) in Edit --> Process. For instance, if a Process has more than 40+ Import actions, then it would be difficult to move a newly added import action/ an existing action to the 22nd place. Thanks Sathya
-
Add 'Does Not Contain' as condition when performing a filter on a text formatted line item
Many of our users would find it helpful if when filtering on text formatted line items, there was the option to use 'Does Not Contain'. There is a 'Contains' condition, which has proved helpful, however a 'Does Not Contain' would also provide a lot of value.
-
VARIANCE command
When we define an item we can set the number Format to Numeric and tag if an "Increase in Value" is Good/Bad/Neutral. Why do we not have a VARIANCE function to utilise that increase in value indicator? So if we have three different Versions ("Actual", "Budget" and "Actual vs Budget" and 1 item called "Sales" (with an…
-
Formula Bar Changes Color When It Is Active
It would be helpful if the formula bar changed color when it is active. As an indicator, This could help people avoid clicking around on different line items and entering in incorrect formulas. See the screenshot below as an indicator of what this could look like.
-
Is there a way to set a numerical goal and track its progress throughout the quarter on a Dashboard?
I am looking for a way to communicate a sales goal by product and channel on a monthly basis. Please let me know if you have any ideas, Thanks!
-
Restore Open Dashboards and Modules Tabs when Model is closed accidentialy (or due to login timeout)
I'd like to see an option that we re-logging into Anaplan - I can re-open my most recently used model and any correspoding tabs (dashboards, modules, etc.,) that were open. Sometimes the model is closed automatically after login time-out, other times the model is accidentially closed by selecting the Anaplan logo at the…
-
PROPER() Functionality
When we are dealing with Text formats in Anaplan it is case sensitive and it throws unexpected results if we don't do it exactly the way it should be. Although we can achieve this by amalgamation of LOWER, UPPER, FIND, LEFT & RIGHT functions. Having PROPER function would greatly reduce the need to do so.
-
Dependent dropdown - Based on line items
HI Team, Just realized that the dependent dropdown will work only based on the property that the list has. As we are following the best practice not to create properties in a list, can we make the dependent dropdown based on line items. Agree/Disagree or Any comments? Regards, Kavin.
-
Display Hierarchy Codes against parent nodes in line item
When creating a module with a hierarchy dimension, if the code is used as a line item, the code will display as blank for higher level nodes in the hierarchy. This is not the case in the list screen for example and is very disappointing for business users used to other tools who do not like the workaround of including the…