-
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…
-
Open source module link in NUX
Suggest to add the "Open Source module" ability to the NUX, incl. the current analysis options available in the old UX. Right now our users can use the open source module function in the old UX whenever they want to dig into the details, see all the underlying formulas/comments, and do ad hoc analysis. Especially, the…
-
Add formula drill down in NUX
Suggest to add formula drill down to NUX. When working with the NUX, there is no formula drill down option. This is a key feature for our users as they need to see how the numbers are being calculated when doing root cause analysis. At the same time, the specific values going into the formula should be shown as they are…
-
Ability to exclude zero values from AVERAGE calculation
A common requirement we see on customer implementations is to be able to calculate the average of a set of values but exclude zero values. For example if we have the following set of values (10,0,0,8,0), the average excluding zeros would be (10+8)/2 = 9. The current AVERAGE function cannot exclude zeroes and so gives an…
-
Is there a way to set a numerical goal and track its progress throughout the quarter on a Dashboard?
I am looking for a way to communicate a sales goal by product and channel on a monthly basis. Please let me know if you have any ideas, Thanks!
-
Time Ranges Notes
I would like to have Notes available to be able to record comments against a Time Range so as to give more clarity as to what the Time Range is used for and whether it needs to be rolled forward at a Year End as in some cases there may be no need to change the start year of the time range for instance but without knowledge…
-
Restore Open Dashboards and Modules Tabs when Model is closed accidentialy (or due to login timeout)
I'd like to see an option that we re-logging into Anaplan - I can re-open my most recently used model and any correspoding tabs (dashboards, modules, etc.,) that were open. Sometimes the model is closed automatically after login time-out, other times the model is accidentially closed by selecting the Anaplan logo at the…
-
Ignore Value Parameter for MIN Function
When using a minimum function, it would be ideal if we could exclude specific values, or a list of values, to avoid returning zeros or another value. For the aggregation function x[MIN:y] you may want to exclude zeros from the formula. Currently the workaround is to use a large number in place of zeros, eg: "IF x = 0 then…
-
PROPER() Functionality
When we are dealing with Text formats in Anaplan it is case sensitive and it throws unexpected results if we don't do it exactly the way it should be. Although we can achieve this by amalgamation of LOWER, UPPER, FIND, LEFT & RIGHT functions. Having PROPER function would greatly reduce the need to do so.
-
Selective Module reordering
I often find that I want to re-order modules within functional areas, but using the ascending/descending order, re-orders all module, not just the ones selected. It would be great if the sort, could be restricted to the highlight modules The following shows how it could look Note that the other modules are not included in…
-
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.
-
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…
-
User list used as a dimension, allow to create a subset to reduce module size
I would like to use the user list as a dimension so users are not overwriting each others settings, but the module with the data the settings select is big and so is my user list, so this adds a lot of unnecessary model size. Can't there be the ability to create subsets of the user list when used as a dimension, like for…
-
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…
-
Display Hierarchy Codes against parent nodes in line item
When creating a module with a hierarchy dimension, if the code is used as a line item, the code will display as blank for higher level nodes in the hierarchy. This is not the case in the list screen for example and is very disappointing for business users used to other tools who do not like the workaround of including the…
-
Please fix opening a menu from the drill-down view (i.e. to open the source module)
Hi, Currently, if you drill down through several layers of modules and try to open the menu of a module to open the source module it appears as if the menu has not opened. I have learned from experience that the menu does actually appear, but seemingly in a random position further up from the drill down tabs, and floats…
-
Add Automated Line Item Reference if a Field is used in an Import/Export action
It would be extremely beneficial and time saving if you could add a reference to a line item that states if it is being used in any import or export action and what that action is. This would be similar to if a line item is used in another line item or module.
-
Breakback function by selected Line Item
Hi Team, It will be great to have an option to select the Line Item which will be taken as a source to calculate phasing for Breakback function. At the moment split is done based on the items, in which I input amount. Unfortunately in some business cases it's required to use another metric for phasing. This can be useful…
-
Automatically re-open modules after a session timed out
Hello All, As a new model builder I have experienced some frustration with tracing back where I was at if my session times out. This is especially true during the development stages and the solution is moving fairly dynamically and several developers are working on it. It would be a nice improvement if Anaplan could cache…
-
New Function To Convert Date Format to Text Format
It would be very useful to have this functionality rather than convert to numbers through DAY, MONTH, YEAR and back to text through TEXT function. Best practice would dictate to split these functions out but this increases clutter and causes unnecessary calculations in models.