-
Dates in Timesum
Timesum formula currently works with time periods. When the granularity of the data is Days, the formula cannot return anything (although it does not generate an error). The idea here is to enable Timesum to also work with Dates so that we can apply this formula to more granular use cases.
-
Add XOR formula
Title says it all, a XOR formula would be really helpful and reduce formula length when trying to test an exclusive or. For those unfamiliar, here is the logic table for XOR. It acts as an OR however if both inputs are TRUE, then XOR returns false.
-
Analogue of SELECT CASE function
This would allow to exclude nested IF-THEN-ELSE constructions.
-
Defaulting values for line-items (vs. modeling via override)
Abilty to have by default a 100% value in a line-item vs. modeling this behaviour with a line item of 100 and putting an override if you do not want 100% (e.g. redemption rates). The default should be able to have a formula behind it. (cfr STET functiona in competitive products) Benefits : 1) Huge UX improvement on…
-
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…
-
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…
-
Alphabetically sort List Subsets by name in '"Applies To" popup
It would be great if List Subsets could be sorted alphabetically by name in the "Applies To" popup when changing the dimensionality of a module/line item. When creating a new module, subsets appear under the main list which is very easy to find, however in the "Applies To" popup it's all over the place. This makes it…
-
Quick way to open referenced Line Item or List Property
It would be great to have a quick way to open a referenced Line Item or List Property from an existing formula. It can be very tedious & time consuming to hunt through the modules & lists, then again through the line items & properties to locate the reference, especially when there are multiple levels of references to…
-
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…
-
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…
-
New UX for modeling: Formula broken down into lines & color coded
In the new modeling UX, it would be great if the formula is broken down into lines and indented when different parts of the formulas are in use (especially for multiple IF statements). Right now, even though the colors change per formula, it's hard to find where the breaks are. Additionally, right now every IF statement…
-
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.
-
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…
-
Show calculation time directly in model
Would be very beneficial for the model builder to see the calculation time (e.g. from model open) of the individual line items with formulas. The current cell count is a great help when it comes to optimizing the model and identifying how to reduce the size hereof. However, the calculation time of the different line items…
-
Expand column width in Actions-Imports (and Import Data sources) or make it adjustable
The idea is very simple. The columns' width in Actions tabs are very narrow this always requires to Copy and paste to excel every time i want to check something in it. Would be great if we could adjust or simply have the default width much wider. @GeorgeDuckettMaybe your wonderful tool could have it in future release?
-
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…
-
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…
-
Function to Count Booleans
There are occasions in a model where I want to count the number of True or False boolean values. Currently the only way to achieve this is to have another line item with an IF THEN function to create a 1 or 0 and then sum the line item. It would be great to have a function to do this automatically.
-
Apply DCA by User Group/Role
The ability to have user specific DCA is great as it allows fine grain control of line items/modules without add dimensions to them, but... As we are dealing with large models with increasing number of users the DCA modules themselves can become very large thousands of users by thousands of CC plus maybe a few other…