Hi, I believe this would be a very impactful tool for model builders and power users. The idea is to help write or verify a formula. In its most basic form, the tool would auto-indent formulas just like in an app like xcode: IF X = Y AND BooleanVariable THEN VariableX[ LOOKUP : LineItem ] ELSE VariableY[ SUM : LineItem ] A little version of that is already available in the drill-down functionality. In fact, I tell clients to use the drill-down functionality to check their formulas. If only the basic indentation of the drill-down menu would appear when you re-open the formula input field, already this would be a big improvement. Then if colors are added, it would make it even better. I suspect, doing this may require a level of syntax check as you enter the formula. This would go hand in hand with several other requests to check the syntax before submitting a formula, one of which is already on the roadmap: https://community.anaplan.com/t5/Idea-Exchange/Alert-Model-Builders-of-Incorrect-Formulas-References-Prior-to/idi-p/36137 A sort of formula builder that helps you structure a formula, analyze an existing large formula, and check the syntax would save a lot of time. There are a few browser plug-ins circulating, to help with basic indentation of IF statements, which highlights the need for such a tool. Thank you,
... 查看更多