-
TEXT() function to follow Excel rules
Being a Anaplan builder, I would like to extend TEXT() functionality to work similarly to excel function, exactly: 1) Follow different format conversions 2) Follow preset patterns, to exclude unexpected text from numbers results etc. Example of wrong work to be prevented with new functionality: Text(1504322.40)= 1504322.4…
-
Show all references (full chain) from a line item in the model map
I would like to visualise a calculation reference chain from a line item as a starting point using the model map. This will help in maintainability of the model and in the ability to refactor model design or calculations.
-
Re-Order Conditional Formatting Rules
Hi Anaplan, When you have multiple conditional formatting rules or you create a new conditional formatting rule you currently cannot re-order the conditional formatting rules. This can make it difficult when reviewing conditional formatting rules to understand what you have defined. It would be great if you could re-order…
-
The ability to see entire Note, Applies to, Referenced By fields inside blueprint view
It would be great ot see the entire Note section in the blueprint view without having to copy and paste it into another tool, double click into the note section, etc. Double clicking into the note section isn't ideal in Standard (Non-Deployed) models, as it can lead to the accidental editing/deletion of the note field. One…
-
Copy/Import Line Item Formats
To provide self-service modeling we need to allow users to not only add new line items to a module but also to change/update the formats. It would be nice to be able to import line item formats as well. Line items can be imported but then only a model builder can change/set the format. For example: I want to give my users…
-
Show Subsets in the General List area in settings under the List they belong to
I would love to see the subsets created under the list they belong to in the General List area in settings. It would make using them and maintaining them easier. And, when learning new models, it's really hard to tell the difference b/n a subset and a list and to what list the subset belongs to.
-
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 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…
-
Ability to sort the order of views on a module using Ascending or descending options
Currently when you click Manage Views on a Module you can move a view up or down to change its order. It would be easier if we could have the option to sort in the same way for other objects with an ascending and descending order option or a top or bottom option. In addition you can only move a view once in either an up or…
-
Totals position for formatted list items
It would be very useful to be able to adjust the behaviour of the totals when displaying a list formatted item. Within a module one can control where the parents appear; it would be good to give this option for list formatted items too. It is possible to "create" this behaviour using dependent drop downs or by activating…
-
Defaulting values for line-items (vs. modeling via override)
Abilty to have by default a 100% value in a line-item vs. modeling this behaviour with a line item of 100 and putting an override if you do not want 100% (e.g. redemption rates). The default should be able to have a formula behind it. (cfr STET functiona in competitive products) Benefits : 1) Huge UX improvement on…
-
Ability to view a module side-by-side with it's Blueprint mode
When model building I find myself regularly want to see a module AND it's blueprint mode simultaneously so I can scan formulas, change things in blueprint, and immediately see the effects without having to toggle back and forth. This would be like using split screen in Excel to compare two workbooks side-by-side Toggling…
-
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…
-
Shared weeks (splited by months)
We use ISO calendar split. This mean that a year contains about 52 calendart week and about 63 shared weeks: when a week is located in two months at the same time. This is the only way to move back and forth between Months and Weeks. Currently we have to maintain false Time hierarchy in order to have this option.
-
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”…
-
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
-
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…