-
Open referencing modules and related lists
As a model builder I want to be able to open modules which are referenced by selected module as a blueprint action. This is how I think it could look like: Also I want to be able to open list elements used as dimensions oth the module. (we could not have it in classic US as we could not open multiple lists but now we can!)…
-
Auto sorting subsets list when choosing Applies to or Format
As a model builder I have to search through "the list of the lists" to select necessary dimension in Applies to or a list for line item format. Most of the lists are ordered the same way as we put them in General lists and Line item subsets tabs using "Reorder..." button. But apart from that we have Subset which can be…
-
Percentile formula
It would save a lot of time and space to have percentile formulas in Anaplan. Percentiles are very valuable to eliminate extreme values from data sets and improve the accuracy of our forecasting models. Having a percentile formula would address the need for a median formula at the same time. Further below are a few…
-
IFS function
One of the most powerful "recent" functions I've used in Excel is IFS(), where a single statement can replace multiple levels of IF THEN ELSE statements. From Microsoft's description: Generally, the syntax for the IFS function is: =IFS(Something is True1, Value if True1,Something is True2,Value if True2,Something is…
-
AND and OR logical operators
In our work we need to frequently use several layers of nested IF THEN ELSE statements. These could be greatly streamlined by introducing IF and OR logical operators to Anaplan. For example: IF A = 1 THEN IF B = 2 THEN TRUE ELSE 0 ELSE 0 could be replaced with IF AND(A = 1, B =2) THEN TRUE. In this context, these operators…
-
Create an export to CSV option for the Pages Report in the new model experience
Can we create an option to export the pages report as a csv in the new model experience?
-
Version Subsets
Ability to create subsets of the versions list Benefits: This will allow versions to be used much more versatile way, as the model-builder will be able to specify which versions will show up in which modules. For example, use forecast & actuals in some modules, but use V1, V2, V3 for scenario planning in other modules.
-
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…
-
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…
-
Ability to Select Isolated Cells in Quick Sum Bar
When using the quick sum bar functionality (https://help.anaplan.com/anapedia/Content/Modeling/Navigate%20Anaplan/Quick%20Sum%20Bar.html?_ga=2.86794650.366156822.1550101511-1666663741.1546456255), you are currently only able to select "blocks" of cells (a series of cells in adjacent rows/columns). It would be useful to…
-
'List Item' Scope on Formulae
Would it be possible to implement a 'List Item' scope similar to Version Scope against line item formulae within Anaplan. My thinking here would be to allow some list items to be driven by inputs, and other list items to be driven by a formula. This would be a huge enhancement, but in than vein I am unsure as to how…
-
The ability to select module measurements in Formula scope
Please, add the ability to select module measurements in Formula scope. With this feature you can use both manual input and formula in one LI, not only using the built-in versions, but also the lists and subsets. Advantages: 1. Reducing the number of Line Items. No need to duplicate LI for fact and forecast input. 2.…
-
Sort Line Item Subsets
Description of the enhancement required: Ability to sort line items the same order in the subset as they are in the originating module Example of the enhancement: A Line Item Subset for P&L report that he is using in another module; however, the line items in the Subset are not in the same order as the Line Items from the…
-
List subset from formula
I'd love to have the ability to create a list subset from a formula. That would give a great way to pre-filter and limit sparsity in modules.
-
"Missing" argument from "SUBSTITUTE" formula equivalent vs Excel
Anaplan's "SUBSTITUTE" formula has three arguments whereas excel's has a fourth optional argument that would allow for much simpler identification of specific substrings within a string that varies in construct: Anaplan = SUBSTITUTE(Text to search in, Text to find, Replacement text) Excel = SUBSTITUTE(Text to search in,…
-
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…
-
haschildren(List)
There should be a haschildren() function that takes in a list that a module is dimensioned by and returns a boolean, indicating whether or not the list member has a child. This would be especially useful in conditional formatting with multiple dimensions, where for one of the dimensions, you do not want the conditional…
-
Anaplan Map Chart of India
Hello Team, Anaplan map chart is very useful display for the users however it's restricted to only few countries in Anaplan. Currently I have few Indian Clients who are actively looking for India map chart. Do we have anything in the pipeline for the same? If not, I would suggest we include that in future release, it will…
-
Display fiscal year label as FYXX/XX for cross year configuration
Hi, My company is using a fiscal year that is not aligned to the conventional Jan-Dec period hence it will cross over the calendar year. In the Time settings, we can choose to align the fiscal year label to start or end month but the format is still FYXX. However it will be clearer if we can use a format like FY22/23…
-
Option to **** Formula Error Toasting
Most of the modelers know what is wrong with their formula, the moment they press enter and it starts toating system. There should be an option to **** the error processing in case of formula errors.
-
Breakback for line items with Boolean format
As a model developer, I want to have option to set Breakback for Boolean input line items. This would be great especially for filters, using multi-level filters based on one Boolean line item can become easier. It should work if summary is set as "Any" or "All", and Breakback is ON for the line item, then clicking on…
-
Drilldown highlights relevant logic string
When a user uses the drilldown feature it would be awesome if the platform highlighted the particular logic string that was being applied within the formula to determine the final result. This would be helpful to parse long, complex formulas with many possible results. For instance, sometimes formulas have many IF a THEN b…
-
Lists and Roll-ups in New Modeling Experience
I love the new Model Experience, but I miss the classic model experience in terms of viewing Lists and Modules on the same page. It would be great if we could add the Lists and Roll-ups functionality in the new Modeling Experience. As a model builder, we could see the Lists and Modules on the page together as we had in the…
-
Need export "tab" vs. copy/paste
A csv export of the Import Tab in the actions Menu would be great
-
Allow a Process Action to have other Process Actions within it
I have a 26 step process in my Model (Process A). I have created a new, 31 step, process (Process B) . I have just realized that I would like the user to always run Process A after they run Process B. Currently this now means editing Process B and individually adding all 26 steps that are in Process A. Request: Allow the…
-
Provide the ability to filter+sort modules in the Modules in particular in the "Applies too" column
In short the title explains the proposed improvement. When you have larger models or multiple MB working on a model, giving the ability to quickly find and sort makes finding other places that someone is using the module to complete significantly easier and quicker so you don't duplicate work, can reference other modules…
-
New Model Experience - Formula Editor Function Tool-Tip
To further enhance the modeling experience, particularly for new modelers, having a hovering tool tip when typing parameters within a function would be useful. It could be structured such that after typing the start of any function, a hovering display lists the required/optional parameters needed. As an example, typing…
-
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' =…
-
Ability to Turn Show Users Off at Line item level
If a line item is formatted on USERS, end user should not be able to see any other USER but himself in the dropdown and they should see only one name in the dropdown. Admins on the other hand should be able to see all. Hence the idea of Show Users: off at Line item level even if the module is not dimensioned by USERS. As…
-
Disallow un-assigning items using the 'Assign' action
Description of the enhancement required: Disallow un-assigning items using the 'Assign' action. There's a left-arrow in the assign action that will delete an existing list item. It would be great to have an option to disable that arrow, or disable removing existing items this way. An example of the enhancement: Admins…