Recognise zeroes and blanks as different data inputs when using number formatting

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.

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.
5 Comments
Community Manager
 
Status changed to: Needs Community Support
Contributor

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 Manager
 
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.