-
Today() Function
I'm wondering why in Anaplan we can only have to input current period in Time. As we're using Anaplan as Supply Chain planification tools and we work really at planning on days level. So it's necessary for us to determine "today"'s date. The solution we use now is to launch an automatic import and update the "Today" item.…
-
Number Formatting Precision / Stop dividing by 1000
I would like to propose a feature to instead of dividing by 1,000 to show items in thousands or 1,000,000 to show numbers in millions, that this is handled by the number formatting. This is a little used feature in excel where you can apply a format to a cell with the value $32,500 to display as $32.5. In this case the…
-
Using LOOKUP and SUM with Formula summary method
A detailed description of the enhancement that is being requested. We would like to request an enhancement that would allow to use LOOKUP and SUM with Formula summary method. Currently Anaplan doesn’t allow to do so, although in many cases it is needed and doesn’t break the math. If available, could you please provide a…
-
Formula for Subsets
Add in a formula functionality to conditionally add items to a list subset, rather than having to manually check a boolean.
-
Automate start of Workflow with Cloudworks
Currently Workflow has to be started manually. Would like to schedule a Cloudworks task that would initiate a workflow
-
Need a way to identify line Items being used as Filters.
There needs to be a way to identify line items that are being used as Filter in same module or any other module, This would be totally helpful while deleting line items that are no longer required.
-
Make the "model open analysis" available
It is very common to face performance issues with Anaplan models. Examples are not lacking, you just have to have a look to Anaplan Community to realize it. Several “best practices” exist: https://community.anaplan.com/discussion/33530/oeg-best-practice-plans-this-is-how-we-model Moreover, a tool exists, the “Model Open…
-
Dynamic Sum based on Multi-Select in Context Selectors
This is an extension of already requested options to select multiple items in a UX context selector (for reference, see that Idea here and here). I wanted to call out the specific request that it be possible to have dynamic sum based user-selected context items. The point has been mentioned in these Ideas here above but…
-
Scaling a number in number format options
In Anaplan it is not possible to scale a number. i.e. show the value of a number in Millions or Thousands. Instead we create a scaling line item and divide all the related line items by this. It is a repetitive work. In New UX I have noticed this when bringing numbers from the source. Scaling option can be accommodated in…
-
Apply DCA by User Group/Role
The ability to have user specific DCA is great as it allows fine grain control of line items/modules without add dimensions to them, but... As we are dealing with large models with increasing number of users the DCA modules themselves can become very large thousands of users by thousands of CC plus maybe a few other…
-
Dates in Timesum
Timesum formula currently works with time periods. When the granularity of the data is Days, the formula cannot return anything (although it does not generate an error). The idea here is to enable Timesum to also work with Dates so that we can apply this formula to more granular use cases.
-
List property formula functionality to match module line item functionality
Hi Anaplan! It would be great if when you are entering a formula within a list property/attribute you can select another list item property by clicking on it instead of having to enter the name each time. This would also need to apply when referencing a modules line item, so clicking on the line item when a formula is…
-
Comments within formula
There should be a syntax to add comments within the formula. All programming languages provide this feature, for example: /* comment */ is used in Java, plsql. This will help to temporary remove any part of the formula for testing or add meaningful comments for reference.
-
In blueprint view, show if a line item is used in a filter
In blueprint view, we can see if a line item is referenced by a formula, but not if it's used in a filter. When cleaning models, we can end up deleting items used in filters and breaking filters with no warning.
-
Validation Button in Formula Editor
I would like to request validation functionality be added to the formula editor in Anaplan. On large models if a formula is entered incorrectly you can wait 8, 10, 12 minutes for Anaplan to process the incorrect formula. I have seen other application in this space have a validation button for formulas which allow you to…
-
IRR function to operate on a specified time period ranges
Hello team I would propose an idea of IRR function enhancement to operate on more dynamic environment and respect Anaplan time dimension in the same way as TIMESUM function. Why it is necessary? For IRR calculation when the sign of the cash flows changes more than once, for example when positive cash flows are followed by…
-
Use Page Selector Item in Formulas
The ability to use what is selected in a page selector in formulas and filters would be very useful. Although you can create a custom filter with a cell acting like a page selector, if multiple people are on the dashboard and using the cell, it can cause confusion.
-
Allow hashing out of lines in the formula editor
Issue: As a model builder, we sometimes need to alter lines of code in the formula of a module. It would be really helpful if there was a character (e.g. hash symbol "#") that Anaplan can ignore so that model builders are able to quickly remove certain lines of code from being used in the calculation without having to…
-
Limit of 60 chars must be removed in the list item / lineitem name
Hi, The current limit of 60 chracters restricts the users to make sophisticated codes in complex usecases. It would be great if this limit cna be extended. Thanks.
-
Timescale - Working days
I really miss the possibility to select Working days as a timescale not only days. I would like to have the possibility to use all of the "time formulas" that is only to be used when you have a timescale. We do our Supply planning on a daily basis but we only works working days the weekends are closed. what we had to to…
-
Tree View Available even if we have large lists
Hi, Tree View have to be available even if the list is large. Anaplan could show it on different pages. It's a big limitation to the client if they can't see the tree view list.
-
Set the Export File Name at the time of Export
Hi when running a Data Export I would like to be able to choose what the file name should be when exporting the file via a prompt. In an ideal world I would like to be able to decide on a prefix and suffix for the file name. With one of the options either being the date/time or the value I set in a module. One of my…
-
Ability to update formulas of List Properties just like line items
To use the List property in formula, one need to type out the whole list name including property name, that is a cumbersome process. Allowing Reference of List Properties, will save MB time and efforts in wrong typing of name.
-
Search box in 'Model Management' Dialog Box
Hi, When we click on 'Manage Models' dialog box, we get an option to select a workspace. When we select a workspace, we get a list of models to choose from. But in case there are numerous model in a workspace, then it becomes tedious to search for without a search box. Can we have a search box to filter ? Thanks, Aravind M
-
Version on List
Currently, we cannot have versions on a list. It is a limitation that customers run into every day. Below is an example from Red Hat, Inc that demonstrates the challenge that this limitation creates and how having versions on a list could be a tremendous benefit! Account Hierarchy: L1 Geo L2 Group L3 Region L4 Sub-region…
-
Ranges/allowable values for number input
It would be handy to restrict a number format. This will save additional validation checks/visualizations. e.g: - Number needs to be positive - Number should be an integer -The number should be within the range of 0-10 This is like a dependent drop-down list, however now restricting the number formatted input.
-
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…
-
Module Selection for Line Item Subset With >1000 Modules
We have encountered a bug where if there are more than 1000 modules in a model, the panel where you select a module(s) to assign to a line item subset does not work. There is a workaround available (provided by Anaplan support to us about a year ago) where we can look at the web-page elements and find the code for the…
-
Planning Gross Margin % and other Ratio metrics at levels above the bottom level
Pretty much everyone would agree that Gross Margin % (GM%) is a REALLY important metric when planning your business. It’s a key performance indicator for healthy past performance, and a key driver for future investment decisions and performance management. Employees are frequently bonused on revenue and margin goals – so…
-
"View-Only Workspace Admin" - new access type
I know this idea has been discussed but I don't find an Idea in Idea exchange that exactly corresponds. I have had some customers request a new technical user access that is a "View-Only Workspace Admin": users that can have the ability to view everything in the model settings (the models, lists, line items), but not the…