-
SUMPRODUCT function
Analogue of SUMPRODUCT function in Excel
-
FIND list items by property value
Currently you're only able to use systm properties: Name and Code to identify List elements. Please add an optional argument in a FIND functions that would allow to use any single exact property in the selected list as a reference.
-
Code property
ITEM is not an occupied system property while CODE is. This makes the formulas ITEM and CODE not equivalent and thus inconsistent for Anaplan modelers. Since CODE() and ITEM() are very similar formulas, it would be nice to make their syntax similar. The practice that we use to keep formulas simple is creating “item”…
-
LOOKUP towards a line item that has less dimensions
Please add an option to use LOOKUP function towards a line item that has less dimensions. For example: I have a line item that has three dimensions: * Client * SKU * Month I try to get some masterdata from Region, Month level that doesn't have SKU dimension. When I try to use [LOOKUP: Client.Region] towards this line item…
-
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…
-
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: *…
-
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 ……
-
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
-
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…
-
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…
-
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…
-
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.
-
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.
-
Custom Format for Lists
Currently all list items default to text. It would be helpful to add them as dates, numbers, 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.
-
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.
-
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.
-
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…
-
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…
-
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 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…
-
Pre-emptive alert for Anaplan function constraints based on total number of cells to be processed
A pre-emptive alert for Anaplan function constraints based on the total number of cells to be processed would be useful to detect issues early in the ALM data transfer process avoiding the synchronization unproductive time until the error or warning message regarding the same kind of effect pops up.
-
Ability to Set a Character Limit in a Text Field
In certain cases the Name of something that goes into a report can only be so long before it starts to conflict and overlap with something else and make the report unreadable. In other cases the user is expected to be concise and not write a whole dissertation to name something or. I'd like to be able to set a numerical…
-
LAG function constraints don't allow for some valid scenarios
I would like to submit an enhancement request for the LAG function to be used between time ranges that are not the same but have valid overlap. The constraint that disallows the use of LAG between any line items that do not have the same time range gives the function minimal utility. I understand disallowing instances…
-
Optimizer on rearranging Applies To for optimal performance
In our current models we have been struggling with performance. 1 big impact is the arranging of applies to. It would be great if we have an optimizer that could determine the optimal Applies to for the performance of a given model. This is based a certain constraints from what i understand 1: Size of given list 2: Arrange…
-
Apply module defaults for timescales
I would like the option to use the "-" setting for time settings in the module blueprint, as per the Applies to Since I rarely use subsidiary views, if I need to change the time from, say week to month, I then have to apply this change to all line items, whereas using a default would save time
-
Day level calendar setting
Is it possible to have a 'day' level setting in the calendar type. We need to plan at a greater level of time sensitivity than is currently available. At present, we use Anaplan for weekly and monthly - it would be great if we could do the same for daily too.
-
Show first 100 rows in Drill Down
The message received when trying to drill down onto a cell which references a large list is as below. Instead, can there be a enhancement to add the grid filtered down to the first 100 rows so that users can continue troubleshooting in the Drill Down window? Thanks! Cannot display grid for line item <sample line item> too…
-
Bounty Program
This is a platform to share ideas about improving Anaplan platform. But there is something I would like from your side a bounty program, for finding bugs in the platform. Just a suggestion to improve the Anaplan platform further. Thanks, Vamshidhar Reddy
-
Line Item Format from module
It would be useful to see attributes of a line item without having to revert to the blueprint view I often build formulas in the normal view because I can see the results immediately. It would improve efficiency if I could see the list format, for example, without opening the blueprint view Maybe through a hover over or…