-
SUMPRODUCT function
Analogue of SUMPRODUCT function in Excel
-
Allow specific list grouping within the Admin Settings Panel
At present , the Admin settings panel used by model builders to create and build new lists for their modules and driving functions do not have the specific list grouping feature. Under Lists and Roll-Ups , we only have General Lists acting as the parent for all lists within the model. To create a better understanding of…
-
More options for TEXTLIST
There is currently no way I can use TEXTLIST function with both unique values AND mapping. * Either you can use parenthesis function with UNIQUE property * Or aggregation function with mapping but with entries repeating. To sum up both use cases are incomplete. Please add option to turn on both features at the same time: *…
-
ISNUMBER function
There is currently no way no easy way to identify whether data is numeric or not. The workaround for X is to check the following set of conditions: NOT (VALUE(X) <= 0 OR VALUE(X) >= 0) Currently this is certainly not a consistent approach and there is always a risk that the comparison operators ("<=" and ">=") will start…
-
Analogue of SELECT CASE function
This would allow to exclude nested IF-THEN-ELSE constructions.
-
Ability to use Concatenate (&) in a Select Function
I would like the ability to add an Concatenate to Select Function. For example SELECT: VERSIONS."Budget "&NAME(Current Year). As we have multiple Budget Version, the current version in play and the future version. So in our variance reporting module it would select the correct version as budget. Similar with forecast ……
-
Prompt to open list when creating
I am adding a new list, it would be useful to either open the list immediately afterwards (or prompt for opening). This could work in the same way as creating a module. The logical next step to creating a list is to add members to the list. It would be more efficient to be able to add members to the list as part of the…
-
Hide List Property Columns when view is on Dashboards such as the 'Parent' or 'Code' or propety
Hi Anaplan, It would be really helpful if it were possible to hide the 'Parent' 'Code' or any property columns on list views published on dashboards. This is to prevent any destructive inputs such as changing the hierarchy by accident. Thanks, Usman
-
Formula Access Driver
Sometimes we have a list in which some list items should be populated via a formula and some other list items via a manual input. The way to model this at the moment is to create 2 line items enabling to input first and see the final amount that takes into account the formula. Obviously, from an end-user perspective, this…
-
Alias Names for Time, Versions, Modules, Line Items and Dashboards
Hi Anaplan, It would be great for Anaplan to allow users to create alias names for: time, versions, modules, dashboard, list and lineitems. Thanks, Usman
-
Formula for current user
It would be useful to have a formula to determiner a user from the users list so I could write lookup statements to source data from modules with users list in dimensions
-
Current Date and Time
It would be great to have a function to get current date and time. Timezone settings could be common for all users and maintained in the settings section
-
Open a Module in "Line Items" tab by selecting a line item (not just a module)
When I can't remember where I saw a particular line item, I go to Settings ---> Modules ---> Line Items and search for it. When I find it, it would be very natural to just click "Open" in the header. However Anaplan only allows this open button to work if you have the MODULE name it belongs to selected. So I have to scroll…
-
PREVIOUSITEM() formula which is like PREVIOUS() but references a list item instead of time
Hi Anaplan, I was searching for the use of the PREVIOUS function but on a list item but it is not currently possible. @peter_mcanena has suggested this but only in a discussion thread. So as his idea suggests: PREVIOUSITEM(x, y) where * x: Any expression * y: List The expression x must be based on the list y.…
-
Function to return the number of leaf items in a standard or numbered list.
I think it would be very useful to have a function to return the number of leaf items present in a standard or numbered list. Example: QUANTITY(x) Where 'x' is the name of the list, also selectable from 'General Lists'. Reasoning: This would serve as a cleaner way to get the number of items in a list, instead of doing…
-
Boolean Format Options
When boolean is selected as a line item format, there should be an option to have single or multiple selections allowed. Currently, the default is to allow multiple selections. For instance, for single-selection, once one line item has been checked, all of the other line items have a greyed out checkbox that cannot be…
-
Automatic Sum in Drilldown View
Ability to select multiple cells in a drill down window and see the sum on the back end, as you can on a dashboard.
-
Keep Dashboard Tables Anchored
When making inputs to large tables, the dashboard will scroll back to the top after making an entry. The ability to have the dashboard stay anchored while entering information would save time for users. We are having to use the maximize feature for each table to input data.
-
Synchronize to Specific Level of Hierarchy
Ability to select a level of the hierarchy to show and have synchronization based on selection. Ability to have separate tables built out for a hierarchy to drill down into without creating separate modules. If we could select the level to show in addition to having synchronization based on selection it would eliminate a…
-
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.
-
NULL Number Format
Null option for number format. Currently when a number in undefined, it will populate the module as a 0 instead of a blank. A work around is required to convert all of the numbers into text, and then make undefined numbers "N/A". The ROUND(TEXT()) function also causes a large number of unnecessary decimals.
-
Formula for Subsets
Add in a formula functionality to conditionally add items to a list subset, rather than having to manually check a boolean.
-
Custom Format for Lists
Currently all list items default to text. It would be helpful to add them as dates, numbers, etc.
-
Default Home Page to list view
We would like the ability to default the tiles screen to the list view for all of our users. This view is a lot more user-friendly than the tile view, we have had an abundance of requests for model access when the users do not realize that they just need to scroll to the right to see additional pages of tiles.
-
Customize Model Filters
Consider allowing customers to customize the filter categories. App, Geography, Planning Cycle, Environment, and Business Function do not fit our use cases or model categories.
-
Introduce sequential lists (Array or Linked list)
As model builder I would like to make use of sequential lists (Array or Linked list) to avoid circular references. This can be useful in many calculations.. Native functions like PREVIOUS() or NEXT() could only be applied on line items which are on the time dimension. Such functions should then also work for the sequential…
-
Poisson function
My customer needs to calculate the POISSON cumulative results to find out the lambda value that goes above a probability treshold. In a maintenance use case, this is useful for him to statistically determine given a target service level and the past average of incidents how many incidents should occur in the future, and…
-
Right-click a part in a formula ---> take me to that module / List / etc.
Similar to some other feature requests I've made... 1. Open From Drill Down (delivered) 2. Open From Filter View it would help model building workflow if I could right-click a module or list that appears in a formula and it give me the option to open the module, or show the list. Again, this is so I don't have to leave…
-
Don't block manual input if a line item doesn't contain all dimensions of the module
Example: We have a model that is based on dimension A and months and contains 2 line items: -Line item 1 (manual input): applies only to dimension A -Line item 2 (has a formula): applies to dimension A and months If we publish this module to a dashboard with month as page selector, it is not possible to change the value of…
-
Right-Click on an applied filter ---> take me to the module
When Opening a filter, It would be really helpful if I saw a filter I wanted to dig further into and be able to right-click and open the module it's coming from. Currently a user has to back out of the filter view, and go there manually. When there are a few filters I have to screenshot this view temporarily because I…