-
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.
-
LOOKUP does not work on list parents and only leaf items
When a LOOKUP is done on a parent item in a module, the result does not resolve to the column with that respective parent. Subsequently the value shows 0. To reproduce: 1. Create list with leaf item and parent 2. Create module with column 1 as "Data", column 2 as "Parent", and column 3 as "Lookup", using list from 1. as…
-
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…
-
Selecting 'All Periods' does not display all Time periods
Description - Model has a timescale with 6 years and 'Total of All Periods' enabled - Open the dashboard 'Time only dashboard' - Synchronised rows is enabled for the grid 'Time only' (Time on rows) - Select 'All Periods' from the time page selector on the dashboard Expected result - The grid updates to show all time…
-
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…
-
nth occurrence text function - finds nth time a character occurs in a string
I would like the ability to use a function that allows me to search for the nth time a character or string of characters occurs in a concatenated key. Currently, we import text string keys from source systems and derive business information from these strings. For instance, we might have the transaction key…
-
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…
-
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: *…
-
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.
-
SUMPRODUCT function
Analogue of SUMPRODUCT function in Excel
-
Support aggregation over time dimension
Description of the enhancement: Currently if the Source has a time dimension then the result must also when using SUM. Users would like to be able to aggregate over time dimension. How this would help our business processes: It would remove the need to do the following workaround. If you have: Result = A.a[Sum A.b] Result…
-
Increase the limit of characters in Notes section
HI Team, It would be really helpful, if we can increase the limit of characters in Notes section of a module. Currently it has 250 as a limit. I got stuck here when I tried to copy paste one lengthy formula cos I don't want delete the formula instead I might take that for my future reference. Let me know others thoughts on…
-
Extend Date format to include Time (hh-mm-ss)
Description: Being an Anaplan Builder, I would like to be able to have a date format with Time in it (hh-mm-hh) Some of our planning tasks are connected with work with exact timing (Date + Time). Currently, we have to upload this data as text and use RIGHT(),MID(),LEFT() functions to extract values. If we have a customized…
-
Increase in more than 1 million times for Breakback line items
Proposal : Increase in more than 1 million times for Break-back line items Benefits : perform large inputs in break-back for initially very small, but non-zero values, excluding the step of force zeroing values by each cell before break-back.
-
Create export with all Saved Views in Model
It would be really useful if there was a way to export all Saved Views present in a model - currently, they can be viewed in the Contents Panel on the left side of the Anaplan window, but text can not be copied from that section. There is also the Contents area of the Model Settings that is able to be copied and has an…
-
Search Option while Selecting Lists for Module Dimension
There should be an option to search lists while applying to modules. In our use case, we have too many lists/subsets to scroll and select the appropriate one. Changing a dimension is even nightmare when multiple lists are applied to the module. Ideally, It is should be similar to how we add actions to a process ( Click and…
-
Summary Default to None for Numeric Line Items
Can the default Summary for numeric line items be None rather than Sum. This way it's a conscious action to turn the sum on, rather than a need to remember to turn them off. I know there's another post to have this an option that can be set by each module, which would be advanced, but I continue to hear about sums being…
-
Create Function for ADDWEEKS
Please could we have ADDWEEKS as a function to work the same as ADDMONTHS and ADDYEARS the current workaround is to convert the weekly time period into a date then add or subtract 7
-
Ability to copy a List
There are occasions when I need to have a list that is similar in structure or content but serves a different purpose in the application or where I need to have different children but similar parents in the same module. In this case my only options are to export the data, create a new list and add the properties and…
-
ACTUALVERSION()
We currently have the functionality to retrieve the values from the Current Version using CURRENTVERSION() Please can we have ACTUALVERSION() to do the same for the Actual Version This provides consistency and will simplify the modelling experience David