Allow hashing out of lines in the formula editor

m.angeles11
edited February 2 in Modeling Ideas

Issue: As a model builder, we sometimes need to alter lines of code in the formula of a module. It would be really helpful if there was a character (e.g. hash symbol "#") that Anaplan can ignore so that model builders are able to quickly remove certain lines of code from being used in the calculation without having to delete them.

Use Case: This feature could be used to write notes within the formula that might assist another model builder as to why a formula was changed and when. It is also helpful when the model builder is testing variations of the formula and not having to copy and paste previous iterations of a formula.

Example:

Original calculation:

Amended calculation:

In the example above, only the calculation outlined in GREEN would be used in the formula and all rows with a "#" at the beginning of the row are ignored.

21
21 votes

New · Last Updated

Comments

  • I like it - would definitely improve the modelling experience when:

    • Ttrying to debug formulas that aren't working
    • When copying modules and changing the 'applies to' (often you have to copy the formulas out to a file and add them back in step by step which can be slow)
  • Great suggestion, Michael!

    This functionality exists within many other coding languages (e.g. MS VBA, sql) and its presence assists with development and transparency.

Get Started with Idea Exchange


See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!