-
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.
-
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.
-
Attribute Module for Inbuilt Users List
Suppose I have a module with Inbuilt Users list as a dimension (No other list should be used as a dimension in that module). Now if I can create a line item which will pull the attributes from Users Command of Anaplan into this module. Just click and refer. For example If I want to see what is the model role of the User I…
-
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…
-
Ignore blank dates for MIN calculations
I'd like Anaplan to ignore blank dates when performing MIN calculations: MIN, x[MIN:y], and MIN as a summary function. For numbers, I can see why 0 is evaluated since sometimes those are true zeroes, but for dates this makes much less sense. With dates, I would want the MIN calculations to return blank only if all of the…
-
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.
-
Mouseover Hover Text for Model Builders
I think it would be helpful to model builders if there was a hover over option to display the text of a particular element. There are instances where the description is cut off for certain display elements and there is no option to resize columns for that element (I see this most frequently in the Module Blueprint and Data…
-
Add module's name to the Line Items grid in the Modules section
It'd be great to have a module's name in the Line Item's grid. Especially when I extract it to Excel
-
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…
-
Capability to define a Default Value
-------- Edit : There was a problem with the body, below the good explanation 🙂 -------- As a Workspace Admin, I would like to be able to define a default value for some Line Items (list, number or boolean). Ex: When a user adds a new row, I would like that some Line Item to be automatically filled with a default value.…
-
Open modules using 'Referenced By' column
It would be really helpful if the 'Referenced By' column opened all modules associated to the line item (similar to clicking on a functional area name to open all associated modules). This could be achieved by SHIFT+LEFT CLICK to differentiate from selecting the cell rather than following the hyperlink. This would be…