Display Number/Integer 0 as blank in Infotable

[rgurram]

If a column has a value 0, I want to replace the number 0 by an empty string or make it undefined. Is there a way we can do that if the Column is Integer/Number basetype?

[vinakumar]

Hi ,

With Integer datatype any value which is undefined will be represented as 0 . So , it's not possible to update 0 with undefined or blank .

[zyuan1 · Accepted solution]

The Null is part of String type, but not in Number type.  Only if the source property does not have value assigned, and no default value configured , will the property be null.

If you create a new numeric property and did not log value inside, it will work.

[Constantine]

Hello @rgurram,

As a workaround you can try state formatting, which displays zeros as white text on white background.

Regards,
Constantine

[slangley]

Hi @rgurram.

If one of the previous responses allowed you to find a solution to your question, please mark the appropriate one as the Accepted Solution for the benefit of others on the community.

Regards.

--Sharon