一个bout ablack

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 9999999999999999 else x" and then use the summary method Min. Added an additional exlude parameter would eliminate the need for this workaround. Another alternative I've seen is using a subset on the list, but this isn't ideal when you think about values intersecting another dimension, eg: time. If an item had a value one month and not the next, you would have to rapidly rebuild the subset, or you would still return zeros. For the formula, it is simply MIN(item 1, item 2, item n), but adding an exclude could look something like: MIN( (item 1, item 2, item n), (exclude value 1, exclude value n) ) or something similar. I've seen a number of people ask about this, but I haven't seen anyone post this as a recommendation. ... View more

一个naplan notifies customers of releases/platform maintenance that prevent users from accessing the platform for several hours. The only ask here is that Anaplan avoid releasing during quarter end (like this upcoming April 6) as many of our users will work on Saturdays to finalize their tasks, many of which are due the Monday after. Is it possible to avoid down times during month/quarter close? ... View more

Would be nice to have User list subsets based on role, to reduce cell count. My input users don't need user-based filtering like my reporting users. Including the full user list significantly increases the number of cells, limiting this to a specific role would help with mitigate this. ... View more

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. ... View more

Make Versions a list format so we can use with LOOKUP logic based on user selections. Would prevent the need for versions mapped to a pseudo-verison list with IF/THEN logic, ultimately reducing complexity and increasing ease-of-build. ... View more

Have the TEXT function convert the results of the ROUND function identically. ... View more

If we could have 4 nested dimensions, this would enable additional functionality, like JE creation, advanced filtering, etc. ... View more

Would like to see additional enhancements to the API, things like retrieving line item blueprints, list/module editing, list properties, etc. This would enable customers to control their Anaplan environments with various automations. ... View more

Sometimes you may have alternate hierarchy roll-ups or items that exist in other hierarchies--if we could have additional synchronization occur by mapping a property of the list to an item of another list (creating a link between the two) we could produce better reporting while reducing cell count (less modules necessary to achieve the same result) ... View more