-
Enhancement to RANK function when dealing with tied rankings
It would be really useful for certain cases if the RANK function could generate a sequential output when dealing with tied data. Currently, the RANK function can deal with tied entries in 4 ways, MAXIMUM, MINIMUM, AVERAGE and SEQUENTIAL and all handle tied data in a slightly different way but do not generate an output in…
-
Collect () function with multiple/varying formats
The Collect() function is great for collecting values, however; becomes problematic when trying to bring in a combination of numbers and percentages, and impossible when trying to bring in text or list items. It would be great if the collect formula could follow the same formatting as the source module (i.e. no need to set…
-
Additional Argument for TimeSum
I would like Anaplan to add a new optional parameters for Timesum. The formula would look like this, TIMESUM(x, [f] , [t], [a], [at], [ar]) wherein * [at] stands for aggregation type (simple, year on year). If omitted, default to simple * [ar] is the resulting value in absolute amount or percentage growth. If omitted,…
-
Adjust Column Widths in Blueprint Mode
Being able to adjust column widths in Blueprint mode would be great. Rather than having to open an 'Applies to' menu, format menu, or copy and paste notes, and formula references, it would be great to adjust column widths in the blueprint mode. Alternatively, it would be helpful to have a "view" window or cell (similar to…
-
Please improve The function of data export from module Line items blue print view (*Format, Summary)
Dear Team The function of data export from module Line items blue print view is very useful for understanding the model especially in case there are many modules in it. But I found that the important items aren't exported in understandable format, those are "Format" and "Summary" column. Below is the example of format and…
-
Drill to Transaction on a parent item
When user attempts to utilize the Drill to Transaction option on a parent item, the filter is broken and entire items are pulled in resulting view. This is by design because parent items values are a result of the summary on the line item, and not the SUM calculation. The Drill To Transaction is specifically for drilling…
-
Ability to reference a Line Item generically.
I am requesting the ability to use a generic 'me/myself/self/here' reference in functions that require a Line Item. An example: Original: PREVIOUS(Total Average Balance) + MOVINGSUM(Total Average Balance, -11, -10, AVERAGE) New: PREVIOUS(Here) + MOVINGSUM(Here, -11, -10, AVERAGE) The benefit of this is: if the Planner…
-
Enable/Disable expand collapse and save them as a View
As user i would like to have the option to enable and disable the expand collapse of hierarchy/composite lists. It would make the list look like flat and saving this in a saved view would be amazing.
-
Ability to have a line item where comments can be added from leaf to top of hierarchy
Currently as part of adjustment process. users wants to make adjustments at various levels of hierarchy and add a comment to tract the change. Currently we are only able to add commentary only at leaf levels. Ability to have a line item where comments can be added from leaf to top of hierarchy
-
Break back a line item using weightage from another line item
current break back prorates the data based on data in same line item, but was strong need to distribute it based on a different line items data weightage.
-
Identified easily Line items used in DCA like the information "Reference By" for formulas
It would be very usefull to have the information "Reference By" for line items used in DCA. It could be a new column "Reference as DCA by" or add this information in the existing "Referency By" column. Thank you
-
Source Models mapping Vs Import Data Sources/Imports
Hi Team, When we rename the model and remapped to the same model with a new name in Model Settings-->Source Models, it is not reflecting dynamically in Import Data Sources/Imports. To see the new model name, we have to manually re-map the Import actions. It would be great if we have this feature in Anaplan- As soon as the…
-
AgentsASA formula
When working with some of our Call Centre customers, I'm seeing use of AgentsASA being used, whilst we have the Agents formula it would be good to have the AgentsASA as a formula to use. The definition of the formula is not too dissimilar to the Agents as it uses ASA rather than SLA. I've attached the Agents and AgentsASA…
-
Actions - Add a field for date and time action was last ran
Submitting this post on behalf of the customer - Jordan Kinnick Please add a field in the Actions settings that shows the last date and time the process, import, export, and other actions were ran. Also please make sure these are shown in the local time zone of the user which is another problem in the history settings.
-
Brackets in the drill-down view
Hey there, When I drill down into a formula, some brackets disappear and get replaced by tabulation, I suppose. It would be great if we could still see those brackets because if you copy the formula and use for another calculation, you might end up with something totally different because of missing brackets
-
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…
-
More Shortcuts
It would be great if Anaplan supported more shortcuts. In particular, shortcuts that would enable model builders to change the formats of line items instantly. E.g. if a model builder hits B over the format cell, it will instantly change to boolean. M for time period months, T for text. Shortcuts are extremely useful and…
-
Extend model map to drill down to line items
Drill down model map to line item level At present, model map displays the modules and its data flow across the model However, it would greatly helpful to have a provision to drill down the model map from module to line item level and extend the data flow display across line items similar to value driver tree providing…
-
Automatic update of Model names in Source model mapping when model names are changed
Hi, Model names in Source model mapping should automatically update when source model names are changed. Also, the name within the Import Data Sources should automatically get updated based on changed Model names. Can we have this feature? Currently, this is not happening and it is confusing when we debug old actions.…
-
Known Issues on Anaplan Formulas Communication and Subscription
As a model builder and an Anaplan Partner, I would like to be notified of all known issues to existing Anaplan formulas/functions so that I can quickly determine whether the function I am about to use is impacted by known issues and what workarounds are available to mitigate the issue(s) until it is fixed so that my models…
-
'Concatenate' as a Summary Method for Text formatted line item
It would be great to have 'Concatenate' as a Summary Method for Text formatted line item (along with First Non-blank and Last Non-blank). Sometimes, there might be a need to consolidate bunch of text inputs in a line item at a higher level in hierarchy. This functionality would help achieve that. Also, if this summary…
-
Subset of Versions
Can we have a subset of Versions so that whenever needed, we can use single version member in the modules? Currently I can think of one use case when we have to drive opening & closing of periods for users to enable data entry only for a specifically opened period or set of periods. There may be better use cases as well…
-
Isfirstoccurrence - Argument for whether to consider Case-Sensitivity
I think it would be a better option to have as a model builder. Currently, Isfirstoccurrence deals with Case-Sensitive data as separate occurrences for eg. NA and na would both be seen as separate occurrences. There are many cases where, as a model-builder, You don't want this to happen. So, having an argument to confirm…
-
Update Subsets dynamically - Formula driven Boolean
It would be nice to have the subsets updated dynamically using a formula driven boolean linking to the subsets as a formula, just like how we have the option to link Display Name to a formula in a module. This would certainly eliminate much needed efforts of running the action every time when we have to update the subset.…
-
Generate Code for Assign function - similar to display name attribute
It would be nice to have a functionality which can generate code / auto-populate code, just like how a display name is populated. A property, specifying the code attribute could be useful and reduce the effort needed to create actions and line items to generate code. When we create an item using the assign functionality,…
-
Dependent dropdown - Based on line items
HI Team, Just realized that the dependent dropdown will work only based on the property that the list has. As we are following the best practice not to create properties in a list, can we make the dependent dropdown based on line items. Agree/Disagree or Any comments? Regards, Kavin.
-
Pre-calculation check for duplicate line items
I am sure the acute pain felt when locking-up the model for simply creating a duplicate line item is felt by many model builders. Please could we have a simple check (this already happens elsewhere in the model e.g. actions) that ensures there are no duplicate line items before the model is calculated/refreshed? It only…
-
Custom Blue Print View
A simple suggestion to help with the organisation and maintenance of models (and I assume a really simple suggestion to implement): Allow model builders to save blueprint views (in the same way it works for regular views) and even change the default model blueprint view for all modules so that we can change the order of…
-
ALLPERIODS Value function
We currently have time functions to return the MONTHVALUE, QUARTERVALUE, YEARVALUE etc... it would be helpful to add a final function which will return the Time.All Periods value, this would enable developers to avoid having to add summary methods to determine the all periods value. It may be there is a work-around but ran…
-
User List Top Level
The users' list should have a top-level for calculations. Currently, the users' list can't be used for inputting data as there is no top-level so errors occur when referenced by a line item without the user dimension.