Is it possible to override number formatted line item default value to BLANK

Suman Reddy
Frequent Contributor

Is it possible to override number formatted line item default value to BLANK

Hi,

 

Is it possible to override number formatted line item default value to BLANK?

 

Suman.

1 ACCEPTED SOLUTION

Accepted Solutions
AntonMineev
Regular Contributor

Re: Is it possible to override number formatted line item default value to BLANK

Hi @Suman Reddy!

Yes, you can change Number zero format:

Снимок экрана 2021-05-13 в 17.00.54.png

View solution in original post

6 REPLIES 6
ChrisHeathcote
Community Boss

Re: Is it possible to override number formatted line item default value to BLANK

No.

BLANK is not a valid entry for a number formatted line item.

However, you may be able to us NaN which is 'Not a Number' to give you the same result. 

Use =DIVIDE(0,0) as part of an IF THEN ELSE function.

Be mindful that you will see NaN as the result so may not be the ideal solution if the line item is to be presented to an end user. 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
Suman Reddy
Frequent Contributor

Re: Is it possible to override number formatted line item default value to BLANK

Thank you @ChrisHeathcote 

 

Yes, it should be presented to user, may be NaN may not be valid for my users.

 

Suman.

AntonMineev
Regular Contributor

Re: Is it possible to override number formatted line item default value to BLANK

Hi @Suman Reddy!

Yes, you can change Number zero format:

Снимок экрана 2021-05-13 в 17.00.54.png

View solution in original post

Suman Reddy
Frequent Contributor

Re: Is it possible to override number formatted line item default value to BLANK

Thank you @AntonMineev 

 

Yes, It is exactly what i am looking at.

 

Suman.

abhay.kanik
Regular Contributor

Re: Is it possible to override number formatted line item default value to BLANK

@Suman Reddy 

 

I suspect you are trying to override another number formatted line item with a input line item but problem you are facing here is you wont be able to override a value with zero.

Here is a workaround for you, Keep the line item as text formatted and use another line item with formula Value(Text formatted line item)  this will convert your text to number to use it further and default value will be blank also when you try to put zero it will take it.

 

Thanks

Abhay

jairam
Contributor

Re: Is it possible to override number formatted line item default value to BLANK

Hi Suman

 

Anaplan always considers "ZERO" as the default value for any number formatted line item.

 

Considering one of our use case, I am anticipating your use case would also be similar.

We were build an override feature that allows users to explicitly override any demand with "0". In to address this feature we had 2 options:

Option 1 : Create a boolean with same dimensions of the line item. Use this boolean as a Dynamic Cell Access on the numbered line item. User would then be able to select the boolean as TRUE and only then the numbered line item would show a value of "0" or he could edit the value. If the boolean is FALSE, the numbered line item would show BLANK. (Most Recommended)

Option 2: Ask users to Enter an explicit value of "-1" in order to consider a ZERO override. And use "-1" in downstream calculations. (Please do not forget to add notes on the line item, in case you think this is better approach).

Thanks!

Jairam Kamath