Description: As a model builder, there are plenty of times where formulas or references to other modules are incorrect either by mistake/typo or due to lack of understanding formula syntax. Based on our model size, we have to allow ample time for Anaplan to return the error summary, even in test models. It would be great to have an alert when typing a formula (based on line item formatting, module structure, etc.) that helps us rewrite or reconsider the final formula before trying to push it through and watching the model 'spin' for a while.
Example of Enhancement: When line item formatting is inconsistent with the end formula/reference, the border of the formula bar will remain red. This should pick up on basic errors such as mismatched lists or typos. Once the red border is eliminated, the model builder is assured this formula will be processed correctly.
Benefit/Impact: The benefit here would be to reduce time waiting for errors to populate and would help guide all model builders in writing formulas correctly.
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.