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

Accepted answers

All comments

harish_bk

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

PrevContributor

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)

Capture002_1010.PNG

Capture001_1010.PNG

PrevContributor

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.

PrevContributor

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.

PrevContributor

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

smarzo

I don't think the link works?

yashkant

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

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.

kavinkumar

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.

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…