Can we add a number formatting option (text fomatting causes issues for our users) with a default for the cell of blank (if blank then the cell is ignored) and then if a zero is input it is treated as a number.
For example - the default calculation for sales volume generates 50 for January 2018, there is an "override" line to allow the user to adjust this. If the user doesn't input into it then the 50 is taken as the answer, if 40 then 40 is taken, if 0 then the 0 is taken.
Currently the only way we can do this is by using an additional boolean line item which is ticked if the user wants to use a zero override, but this clutters up the model so we would like to eliminate this.
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.