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.

7 Comments
Community Manager
 
Status changed to: Needs Community Support
Master Anaplanner/Community Boss

I end putting in 0.000000000000000000000000000000000000000000000000000000000000000001 or similar to get around this quandry!

Occasional Contributor

Ha! Yes we do that as well but it's not ideal is it! Especially as we have users across our business who are not a fan of workarounds!


 

Community Boss
 
Status changed to: Under Investigation
Occasional Contributor

It would be very useful in order to override by 0 ! Currently we add a boolean line item that users check if they want to override by 0, but it takes screen space and can't be incuded in line item subsets.

Group Leader - Employee

I have a client that needs to be able to override by 0. Their users are sales people and don't understand having to put in .01 instead of 0. Why aren't we able to do this??

 

Regular Contributor
 
Status changed to: Not Planned
Users Online
Currently online: 201 members 1,419 guests
Please welcome our newest community members: