List property formula functionality to match module line item functionality

List property formula functionality to match module line item functionality

Hi Anaplan! 

 

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! 

 

Thanks,

 

Usman

The content in this article has not been evaluated for all Anaplan implementations and may not be recommended for your specific situation.
Please consult your internal administrators prior to applying any of the ideas or steps in this article.
6 Comments
Community Boss

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

Community Boss

Hi @DavidSmith

 

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. 

 

Thanks,

 

Usman

 

 

Community Boss

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

Community Boss

I agree with you it was just a thought from seeing new users struggling during training with list properties.

Community Boss

You'll be pleased to hear that we are changing our training to reflect this

Community Manager
 
Status changed to: Needs Community Support