Explore our best practices, forums, and more for all areas of the Anaplan platform.
Improve your knowledge of Anaplan with in-person and virtual training options.
Join the ranks of top model builders with our elite recognition program.
See what's new and exciting with Anaplan and our Community.
Suggest and vote on ideas to improve your Anaplan experience.
It would be great if when you are entering a formula within a list property/attribute you can select another list item property by clicking on it instead of having to enter the name each time.
This would also need to apply when referencing a modules line item, so clicking on the line item when a formula is active brings in the name instead of having to type it in a list property/attribute.
This would also need to leave the formula active (still connected) when you navigate to another list property or module line item so that you can click on it to bring in the item.
This would allow much more flexibility in using the tool and stop model builders from having to write and save and remember long references.
It would be great to see this on the roadmap!
We don't advocate using list properties for exactly this reason. Keep the formulas in a System module and use line items rather than list properties
I completely understand your point and do agree, but this is less for creating formulas for calcs in lists and more for when you are concating say a property code with a unit code and you have to type the name of both property item and unit item instead of being able to click on them to populate them in the formula. So then for display name we could have a concatenated code. So that the use of formulas and the way we populate them is consistent among the modules and lists. So it more about whats availble from the functionality of Anaplan as a product then best practice.
You can do that in a module formula. Whilst in the formula editor, you can navigate the the Lists and Rollups section. Click on General Lists and then select the list you need to reference. It will be populated in the formula so no need to manually type. I recommend this approach for beginners or when the list contains numbers of special characters, as the 's are often confusing
I agree with you it was just a thought from seeing new users struggling during training with list properties.
You'll be pleased to hear that we are changing our training to reflect this
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.