-
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…
-
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.…