cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

The PTC Community email address has changed to community-mailer@ptc.com. Learn more.

Display Number/Integer 0 as blank in Infotable

rgurram
6-Contributor

Display Number/Integer 0 as blank in Infotable

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

4 REPLIES 4

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 .

 

 

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.

Hello @rgurram,

 

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

 

Regards,
Constantine

slangley
23-Emerald II
(To:rgurram)

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