-
Support of basic excel functions like RAND, RANDBETWEEN, RANDARRAY
It would be nice to have these Random number generating functions. These functions revery useful to generate some test and demo data, rather than inputting numbers and copy forward or importing from an excel. Can all be used for other purposes that I can not think of now.
-
Improve List Item Deletion
Improve the list item deletion within Anaplan so that if a model builder selects 'Delete All' from the delete dialogue when there are vast numbers of list items the model builder is prevented. Doing so would prevent model and workspace lock ups. To explain this further: Consider a list with 1,000,000 items. If you attempt…
-
Add XOR formula
Title says it all, a XOR formula would be really helpful and reduce formula length when trying to test an exclusive or. For those unfamiliar, here is the logic table for XOR. It acts as an OR however if both inputs are TRUE, then XOR returns false.
-
Improve FINDITEM() when used with Time
Similar to improving imports with time periods (Idea Link), it would be great if the FINDITEM() formula was tweaked when working with Time, to make the formula return time periods for strings like Jan-20. Reason for asking (lifted from my previous post in the Idea Link): The standard excel format for Month-Year is MMM-YY.…
-
Drill Down View Enhancements
Drill downs in Anaplan Modules should have a feature for checking what each part of the formula written does. For example if there is a If condition with a nested loop with multiple formulas and conditions in it, then there should be a provision to select what each condition does regardless of the condition being True or…
-
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
-
Dynamic List Management Access
Being an Anaplan user, I would like to dynamically set list management access without admin license. Similarly to WorkFlow and DCA, it would be great to have an ability to dynamically limit add/delete/copy actions on the list for the users, who have write access to it. As per now, taking, for example, Workflow: Imagine we…
-
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…
-
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.
-
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: *…
-
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
-
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.
-
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…
-
Use SUM Rules Dimensioned by Users for Source Data not Dimensioned by Users
I recently posted a question on the forums in relation to a workaround for a bug in the LOOKUP formula. I wholeheartedly feel like the LOOKUP bug (where it doesn't work for parent items that are in the same list as the leaf-level members) should be fixed. And I recognize that there are some workarounds available (as…
-
Format Date Fields so as to include the Day Name
Currently in Anaplan there is no way to change the format of the date to include the Short name of the day such as Mon for Monday without creating a custom timescale as a numbered list and then defining it in the Description of the Item. I have an instance where I need to provide more details on a date for the scheduling…
-
Action type that eliminates need for additional check box
Add an action type that allows for creation of new rows without needing to select an additional boolean checkbox Many actions require selecting a check box in addition to click a button. These should be consolidated into one step to improve user experience
-
Ability to set different summary options for each list a line item applies to
Currently, at a line item level, it is possible to set a specific summary option for Time. It would be beneficial in terms of space and performance to be able to do so for each list a line item applies to. For example, we often have a list called "scenario" with a top level item so that we can create scenarii by "copy…
-
Calculation Function / Formula context specific suggestions
When typing in a calculation function, show a dropdown box that provides possible matches Example 1: In the formula box when you type "Da" a tooltip suggests "DATE, DAY, DAYS, DAYSINMONTH, DAYSINYEAR.." etc Example 2 (List/Module specific): When typing "Employees. " a tooltip suggests your available Properties or Line…
-
Single-precision numeric format option
Number-formatted line items and properties use a double-precision representation internally, and at least double precision during calculations. They are specified in the IEEE754 standard as a signed binary floating point format with 52 bit significand and 11-bit exponent, allowing a range of 2.2*10^-308 .. 1.8*10^308 and a…
-
Make sorting lists easier
It would be nice to sort lists alphabetically with the same button used for sorting modules.
-
Ability to enable/disable multiple filters under "Filter Segment based on data in..."
Description of the enhancement required: I want the ability to narrow down the summaries I see for the parent. If you select a parent, you see all summaries for the child, but I want to be able to have the ability to select multiple parents, or multiple children, while having the ability to exclude others. For example…
-
Display the number of items in a Subset and Line Item Subset
For a List Subset on the Subset tab display the number of items that are included in the subset. Similarly for a Line Item Subset on the definition page indicate the number of items that are marked as being included.
-
Search bar to look for line items in the filter dialog
Insert a search bar right under “Choose Line item” when adding a new filter rule.
-
Allow copy/paste from right click menu (without using hotkeys)
When you click copy and paste in the right click menu in Anaplan, copy works, but paste tells you to enter the hot keys instead. I would like my end users to be able to click paste and have Anaplan paste the value with out them needing to use the hot keys. This would be a benefit as it would help end users that are not…
-
Connecting two subsets in formulas
Description: I want to save server space and put all promo packs to a subset, but I have two types of promo packs, which have different calculations. Eventually I am obliged to sum them up without use of subset, which occupies a lot of excessive space. Example of enhancement: Create total promo packs subsets out of two…
-
Rollback caused by "Is Summary"
Description of the enhancement: When a user incorrectly selects "is summary" for any line item with non simple formulas they hit a rollback. A rollback consists of a model closing, opening, reapplying a changelog, and saving. Can we look into a solution to capture that the formula isn't a summary line item before it causes…
-
Editable hover-over text on cells
Description of the enhancement required: The Hover-Over Tip function: Allows the user to hover over a cell, table, module, model, dashboard or buttons which then shows a short description or identifier for the object. An example of the enhancement: User wants to see a short background description without having to drill or…
-
Ability to create a budget version, copied from another version, with values that don't change
I want a version that contains values from another version, but doesn't rely on lists/formulas/etc. Changes to the model should not affect this version copy. Description of the enhancement required: I want to be able to take a copy of a version which is just a copy of the numbers, so once you agree the budget it is copied…
-
ITEM function cannot be used on composite lists with Summary of "Formula"
To reproduce: 1. Create a parent list and a composite child list. 2. Create a module with 1 line item with formula "ITEM(Child List)" and list formatted to "Child List". Applies To should be "Child List". 3. Change Summary to "Formula", the following error is shown: The formula for 'mod1'.'item1' is invalid: 'item1' =…