Previous Contributor

Blank for numbers

Hi all, Perhaps a straightforward question, however I cannot find a direct answer. I would like to have a BLANK formula for numbers, so IF ... THEN BLANK. Currently I have IF ... THEN 0 ELSE ... , however it has to be blank instead of zero. Is there a certain formula that works for numbers? Kind regards, Mickel

8 REPLIES 8
Super Contributor

RE: Blank for numbers

Hi Mikel I guess once a line item is number formatted there are no blank cells are the cells are populated with a zero, hence you cant write a formula on blank. If you could let us know the business scenario we can come out with a better options like use boolean formatted values on list items or line items and then fulfilling the requirement. Harish
Previous Contributor

RE: Blank for numbers

Hi Harris, Thank you for responding, to clarify the situation in more detail: - When no formula's are used and the upload is done, the cells will display a "-" instead of 0.  (PNG1)  - If I'm using the PowerPoint add-in creating graphs, it will display the periods with a 0, while those are months with no actuals in it. It would be better, if the cells where empty, so the graph does not create a 0 production indication during those months. (PNG2)
Previous Contributor

RE: Blank for numbers

Aswell it seems useful, if I want to make a switching table. For example that shows the current month and three months before, however not with column titles current month, current month -1 , ... But creating a table with list items "Jan, Feb, Mar, ..." and making the data swift dynamically, however filling out the other month columns in blank, instead of zero, so it is very transparent for the viewers.
Previous Contributor

RE: Blank for numbers

I posted a few possible workarounds here: [url=https://community.anaplan.com/forums/-/message_boards/message/4173486]https://community.anaplan.com/forums/-/message_boards/message/4173486 [/url]They're not all pretty but one of them should work for you.
Certified Master Anaplanner

Re: RE: Blank for numbers

I don't think the link works?

Previous Contributor

RE: Blank for numbers

Hi Mickel, How about using another Text formatted Line Item that says IF Original Line Item > 0 THEN TEXT(Original Line Item) ELSE BLANK, where Original Line Item is the current number formatted line item that you're exporting? Let me know if you'd like more details, hope that helps! -Chris Weiss
New Contributor

Re: Blank for numbers

https://help.anaplan.com/anapedia/Content/Dashboards_and_Visualization/Charts/Data%20and%20Charts/Ha...

When formatting Number fields, in Blueprint, you have option to display zeros as Zero, Blank, or Hyphen. This is simply a display option. If you choose to display a Blank cell or a Hyphen, the cell will still contain a zero value.
Certified Master Anaplanner

Re: Blank for numbers

HI,

 

It is possible to bring blank instead 0 in number format line item. Simple go to fromat and change the "Zero Format" to Blank. However if you try to put 0 in that line item it will be shown as Blank.

 

Hope this would be helpful!!.

 

Let me know if you have any concerns.

 

Thanks and Regards,

Kavin.