-
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.
-
Users List as a basic Dimension
Hello, I ran to the several issues when I needed to calculate some values on the Top Users level. * Users list itself doesn't have Top Level and there isn't an option to add it. Therefore you can't get Total number for given line item that applies to Users List. I was trying to do some workarounds (creation of Dummy Users…
-
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…
-
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…
-
HyperBlock Performance Improvement: TRUE-->TRUE change
The Anaplan platform leverages a patented in-memory, Java-based, planning engine for calculation called Hyperblock", as we can read in the CIO Guide White Paper on anaplan.com. The engine allows to rapidly calculate billons of cells. It is also important to understand that it recalculates only what needs to be…
-
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…
-
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…
-
Calculation on top level selection in line item subsets and list item subsets
Hi Anaplan Community, Currently it is not possible to use a summary top level of a list subset or line item subset in a calculation without using a workaround using a boolean and using the complete list or line item list. If anaplan had the capability to allow modellers to use the top level in a line item subset or list…
-
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…
-
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.
-
Merged: User List Subsets Based on Role
This discussion has been merged.
-
Allow Multiple layers of Conditional formatting with more flexible color options
Let conditional formatting options be stackable in layers (similar to MS Excel). In my current model we have a table that uses color across all cells based on the development stage. At times we also want to color cells that have an error to a particular color of red, however this is not possible without stackable…
-
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…
-
Ignore blank dates for MIN calculations
I'd like Anaplan to ignore blank dates when performing MIN calculations: MIN, x[MIN:y], and MIN as a summary function. For numbers, I can see why 0 is evaluated since sometimes those are true zeroes, but for dates this makes much less sense. With dates, I would want the MIN calculations to return blank only if all of the…
-
Defaulting filters in Assign Action Screen
Assign functionality can be used, for example, to add products to customers. But how will we make sure, that only active products will be added? We can define a filter in assign actions (we can't use Boolean as a filter, but we create a list formatted property for that purpose). The main problem is, that when we open the…
-
Performance of line items calculations with cell count 0
Anaplan platform gives to modelers great flexibility in terms of how it is used, once in a while leading to situations, where modelers design solutions, which were never considered by Anaplan Platform developers. One example like that is usage of a single element list with subset as a module dimension - to turn on or…
-
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…
-
Allow the same action to run multiple times within a single process
Description of the enhancement required: Allow the same action to run multiple times within a single process How would it help your business process: There are many situations in which this would be helpful. One example Setting a production plan based on prioritising SKUs. i.e. The capacity of a production line is…
-
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.
-
Capability to define a Default Value
-------- Edit : There was a problem with the body, below the good explanation 🙂 -------- As a Workspace Admin, I would like to be able to define a default value for some Line Items (list, number or boolean). Ex: When a user adds a new row, I would like that some Line Item to be automatically filled with a default value.…
-
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…
-
Line item (Cell) Comments
The ability to add a comment to a line item would be useful, so if we had a line item that was number format, the ability to add a comment eg."increased due to promotion", it gives a narrative for the value in the line item. I appreciate that line items are not fixed (as in Excel cell comments) but this would be a very…
-
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…
-
Bulk Copy Action - Line Item Input
Great addition this past weekend with the Bulk Copy Action so that it can be tied to a process. As another enhancement to this feature - it would be great if the model builder can set line item values to drive the input - similar to the update current period action released prior.