-
Ability to sum based on boolean
Description of enhancement required Ability to allow to aggregate using Boolean mapping. Currently mapping can only be applied over List elements. It would simplify many formulas if we could simply SUM/PRODUCT over TRUE/FALSE Boolean values. An example of enhancement - See example below *List called "Client" with 3 items.…
-
Statistical Functions Package: Normal Distribution
Concept: Include basic Statistical Functions in Anaplan Description: I miss some basic statistical functions among the available functions. These formulas are extremely useful when it comes to calculate chances or risks, which is a common and useful bit within the forecast calculations. A good example is the lack of a…
-
Dynamic Cells Calculation (DCC)
This feature would allow to selectively switch between "Calculation" or "Manual Input" on a specific LineItem. Much like the DCA, the DCC would be based on a boolean. When True, the formula would apply but when False the user would be allowed to type data. This would allow to make Anaplan much more dynamic and greatly…
-
Multiple Summary Methods Per Line Item
Description of the enhancement required: Ability to use different summary methods by module dimension (list) An example of the enhancement: We can currently summarise differently the lists and the time dimension but it would be great to be able to choose a different summary method by list/dimension. For instance if a…
-
Ability to select versions as a list formatted line item for use in lookup statements
Versions are useful as they allow switchover functionality enabling a user to both enter a forecast on a line and see actuals in the same line item. However, comparing versions to eachother (any version to any other version dynamically) requires a "Versions List" and logic to engage that list with the Version you want to…
-
Ability to display negative numbers as positives
Detail description of the enhancement that is being requested: We have numerous requests to have costs displayed as positive numbers but aggregate as negative. The current workarounds are very difficult To provide more clarification, could you please explain how you hope the enhancement would assist in your business…
-
Option to not include current period in YTD calculation but in YTG instead
Description of the enhancement required: YTD calc should NOT include the current week and YTG should include the current week. How would this engancement improve your processes: I do several YOY indexes and they are all incorrect because of this. When I compare YTD this year to YTD prior year there is always extra data in…
-
Week Coverage, also known as forward coverage or stock cover
A description of the enhancement requested Week Coverage, also known as forward coverage or stock cover. As an example we have Forecast Sales and Current Stock. Formula should calculate how many future periods of forecast will be covered by Current stock. This is achievable in Anaplan with below function: Look Forward +…
-
Multi-layer sort
Would be very useful to have a multi-layer sort (not filter) like in Excel i.e. Sort by column A alphabetically, then by column B, then by C. Acknowledging the workaround to concatenate the desired fields into a text line item and sort by that, but to me a publicised workaround is always a pointer to a needed/desired…
-
Set conditional formatting by formula
Description of the enhancement required: Improve conditional formatting by allowing formulas. An example of the enhancement: Have it function similar to excel where formulas can be used to test for conditions. How would it help their business process: Extra line items must be used to check for a condition, if conditional…
-
Function to return the number of leaf items in a standard or numbered list.
I think it would be very useful to have a function to return the number of leaf items present in a standard or numbered list. Example: QUANTITY(x) Where 'x' is the name of the list, also selectable from 'General Lists'. Reasoning: This would serve as a cleaner way to get the number of items in a list, instead of doing…
-
Create a "Date Last Modified" column in Modules to let Admins see when line items were last changed
I would like the ability to interrogate when a Module has received changes to specific line items to help in troubleshooting bugs. For example, when someone changes a line item's summary type, or formular, or data type, or name etc. this should ideally change the "Date Last Modified" for that line item. I could see this…
-
Bulk Copy by Month
In the model, Version section, a user would have the ability to run a bulk data copy between time periods/months across and between versions. The new functionality would include: * Bulk copy - ability to select the specific month(s) to copy from one version to another. * Bulk copy - ability to select the month(s) to copy…
-
Be able to select a default summary type for a model
In the spirit of trying to keep our models size-efficient, we encourage model builders to set the summary type to "none" whenever possible in calculation modules (trying to follow the DISCO method here!). Unfortunately, when a new line item is created, the summary type always defaults to "sum" and it's very easy for model…
-
Enhancement Request for the ability to assign list items to a subset using a formula
I would like the ability to populate a subset based on a line item attribute in another import module that contains the full list.
-
Version subsets and selection as a format
It would be great if you could select Versions as a format of a line item. This would make it much easier to pull data from a specific version into a module without versions, for example using a lookup within a line item. It would also be great if we could create subsets of versions in models where there are many versions,
-
Versions as list format
Make Versions available as a list-format. Benefits: Allows the end-user to select the version they want to look at from a drop-down making for better variance reporting. Allows you to map from a normal hierarchy into a version dimension *Excel add-in needs to support & support with filters
-
Mouseover Hover Text for Model Builders
I think it would be helpful to model builders if there was a hover over option to display the text of a particular element. There are instances where the description is cut off for certain display elements and there is no option to resize columns for that element (I see this most frequently in the Module Blueprint and Data…
-
Make Versions a Production List
Enabling Versions as a production list would allow business users (not developers) to add flexibility and enable business users better management of versions. Consider the scenario where there is a variable amount of Forecasts that could happen in a year, or if a Forecast becomes current/next.
-
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.
-
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…
-
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…
-
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…
-
Add Versions as a native option for a line item/property format.
Description of the enhancement required: Version as a format An example of the enhancement: When uploading a planning file (budget, Q1 forecast, Q2 forecast) from excel, a number of identifiers for my transactions are uploaded as text and later on in the transactions module turned into line items based on a list so I can…
-
Include Formula Change Detail in Model History
Currently the model history process only captures that a line item was edited but it doesn't specify if it was a formula change, applies to, etc... and it doesn't include what the formula is/was. This came up recently in trying to research what had happened with a formula that had previously been updated and it's otherwise…
-
Improved History Granularity in History Report
Description of the enhancement requested: When the client exports the history they want to see the details on who changed the Formula, as well as having an ability to filter out the needed modules, lines, etc. The output is there but they want to be able to filter it online as it is close to impossible to do in…
-
NOW Function
Use case: As a user, I want to display the current time (e.g. 9/12/2018 5:00AM) in a cell. This should behave similar to the "NOW" function in Excel. Business case: When a user presses a button, we want to display the last time the button was pressed.
-
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.…
-
In the drill down window being able to filter on values for non blank or non than zero
Hi Anaplan, It would be amazing if within the drill down view you were able to filter on a list of values for items that are non blank or non zero. So for example if you're looking at a calculation with a dimension that has 1000 items you can see only the relevant items with non zero or non blank values that contributing…
-
Ability to rename a line item without breaking the import mapping
Description of the enhancement: If a line item which is used as the source of an import is renamed, its mapping is removed and the action must be re-mapped. To re-create: * Setup an import from "LineItemA" in ModuleOne to LineItemB in ModuleTwo. The line items will need manually mapping since they have different names. *…