-
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?
-
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…
-
'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.…
-
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,…
-
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…
-
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…
-
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…
-
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…
-
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…
-
MAX() and MIN () functions over time periods
Currently you can compare time periods using operators '=', '>' and '<' which is great and very useful. But when it comes to comparing more than two dates, it becomes a nightmare to find a MAX or MIN. Unlike with number or dates, you either have to go through countless IF THEN ELSE cases which is probably impractical or…
-
modules width adjustment
The module name will be cut off, so please be able to adjust the width of the column.
-
Model Optimising and Housekeeping
I'd like to have new features in Anaplan where it will check your whole model and return the following: * Module/Lists which are not references in actions/dashboards and therefore can be removed without impact * Line items which are duplicated in other modules and are using the same dimensions (therefore duplicated can be…
-
History on Formula Changes
Similar to Cell or Module history, there should be an option to get on demand history on formula changes. An option in blueprint mode to select any line item formula and get history option should be added. This will be helpful to track formula change in multiple model builder environments.
-
Allow for 'Invalid' formulas during model changes
When model building often we get requirements that require changing the dimensions of a line item / changing hierarchy levels etc. Basically things that will break existing formulas. To make these changes to an existing model I'll laboriously go about copying formulas that will break somewhere else, carefully making a note…
-
Built in notepad/clipboard
Hi Anaplanners, This time i am coming with an idea of having a kind of manageable clipboard/notepad built into the development UI. Performing development work i usually have some additional tools like notepad or excel opened on side to able to store formulas or mappings that i want to use in next few mins (example is a…
-
Time Subsets
I would like to see shorter time periods that we could control for example rolling 90 days, 16 weeks etc. Realizing there would need to be some sort of trigger of control set a start point. A potential user story I need to be able to solve is: I plan by month but need a 90 day outlook As part of that 90 day outlook I need…
-
Remember formula bar settings in new modelling experience
It'd be great if Anaplan could remember formula bar preferences either globally at an account level, or by workspace. At the moment, you will perhaps prefer to set the formula bar to the side view, with a specific width, and when re-opening a new module it will be reset to below the data and at default height. This means,…
-
Two Ratio summary - Different for Line items and Time.
Hi Team, Can we have to different Ratio summary for both line items and time. it will be helpful in few scenarios where we have to calculate ratios have to be calculated differently for line items and time. Thanks, Manjunath
-
Show Precedent Line Items
Excel has a great feature that shows dependent and precedent cells for formulae. For those that do not know, here is a screenshot of trace precedents in action: The blue arrow is indicating that Profit is dependent on Costs and Revenue. This is a great visual way to show how cells affect one another. Whilst Anaplan…
-
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…
-
Time Subsets
We would like the ability to create time subsets for more granular time ranges (days, weeks, months), that may not match the current model Time Scale of Years, Quarters, etc.