Recognise zeroes and blanks as different data inputs when using number formatting
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.