About stephen.brook

The ability to run an action to Order list items was delivered in our September 2020 platform release: https://help.anaplan.com/en/7a09027d-894e-4817-9f92-1fd11d018e2a-Order-List-action You can perform a List import in the usual way, and then add a new Order List action to your Process that enforces the sort order you wish to apply. You will probably need to add an extra step to your Import to import the field you wish to use as your sort key into a new line item. ... View more

Thanks for all your feedback - we understand why you'd like this to be available to non-Workspace Admins, and the context in the posts above is useful. We'll examine what it would take for us to deliver this. ... View more

This was delivered in the Platform Update on 24 April 2021, as described here: https://community.anaplan.com/t5/Releases/What-s-New-April-24-2021/ba-p/106294 ... View more

As part of the recent platform updates the first set of ALM APIs have gone live, which include the ability to programmatically run an ALM Sync. You can view the API documentation here: https://almapi.docs.apiary.io We are also evaluating whether we could expose ALM Sync as an Action that could be automated. ... View more

Hi - thanks for your feedback. The behaviour you've observed is a result of the way that the TEXT function works, and it depends on the magnitude of the input value, as follows: For input values smaller than 1e-3, TEXT will always return a result in scientific format For input values between 1e-3 and 1e7, TEXT will return the decimal presentation of the input value For input values larger than 1e7, TEXT will return a decimal presentation for integer inputs, and output in scientific format for non-integer input. So at present, the only way to guarantee that you'll see a decimal representation (rather than the scientific format) for large input values is to ensure that they're rounded to the nearest integer. ... View more

Thanks for your feedback on the MAILTO function. Unfortunately, the length of MAILTO link that we can support is out of our control, and is constrained by the maximum length of URL supported by browsers and mail clients. While there is no formal specification for the maximum length of a URL, most browsers support lengths up to around 2000 characters. For example, Internet Explorer supports a maximum of 2083 characters, per this Microsoft page: https://support.microsoft.com/en-gb/help/208427/maximum-url-length-is-2-083-characters-in-internet-explorer ... View more

我们在2019年4月发行的版本中为客户提供了自助此操作的能力：https：//community.anaplan.com/t5/releases/what-s-new-april-13-13-2019/ba-p/44215 ... View more

感谢这个想法，我们正在评估。过滤挑选列表的能力最初是作为可用性辅助工具实现的，以防止用户必须从许多可能与他们无关的列表项目中搜索。只要您将选择性访问或动态单元格应用到需要确保的数据的列表/行项目中，则不应不适当地揭示单元数据。 ... View more

@Miran - this seems a duplicate of this other entry .... could we combine them? (& their Kudos): https://community.anaplan.com/t5/Idea-Exchange/Time-Ranges-Notes/idi-p/55385 ... View more

Nice try guys, but I think we already have an IdeaExchange entry for that Looking forward to working more closely with you @DavidSmith .... ... View more

The new EXACT mode for the ROUND function, included in the 23 November update, addresses this issue. https://community.anaplan.com/t5/Releases/What-s-new-November-23-2019/ba-p/54370 ... View more

We're pleased to announce that we've introduced a new mode for the ROUND function in this weekend's release that addresses the problem you're seeing. You can view the updated Anapedia content for ROUND here: https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/ROUND.html And we have some guidance notes for customers on the use of the new 'EXACT' mode of the ROUND function: https://community.anaplan.com/t5/Releases/What-s-new-November-23-2019/ba-p/54370 In essence - nothing in your existing models will change, unless you choose to opt-in to using the new ROUND mode by adding the new EXACT keyword. Here's the example from the first post in this thread, showing the new behaviour: ... View more

Hi - thanks for highlighting this. We also updated the Anapedia entry for ROUND this morning to reflect the new EXACT mode - we've added some more example uses as well: https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/ROUND.html ... View more

I'd like to gauge the views of people on this thread on a narrower consideration around Time period labels. While we understand the drivers for a more flexible scheme, e.g. to provide 'aliases' for Lists generally, we have feedback that some customers have specific concerns around the 'FY' prefix used in the labels for aggregate time periods, e.g. for 'Q1 FY19' or 'FY19'. In cases where customers would rather not see the 'FY' prefix used (e.g. because their model doesn't actually represent a fiscal year), would the option to use a 'CY' prefix instead be of value? ... View more

Please note that this is already possible (for two revisions of the same model). See the section titled Compare Revision Tags in the Same Model here: https://help.anaplan.com/anapedia/Content/ALM/Revision_Tags/Working_with_Revision_Tags.html ... View more

The modeler can achieve the same effect with a simple formula. Imagine a numeric line item called Input. The last non-zero value (across a timescale, assuming that's the use case) can be computed for a line item Output using Output = IF Input <> 0 THEN Input ELSE PREVIOUS(Output) ... View more