Skip to main content
rgurram1-Visitor
1-Visitor
April 6, 2020
Solved

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?

zyuan1Answer
5-Regular Member
April 8, 2020

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 in thread

4 replies

vinakumar12-Amethyst
12-Amethyst
April 7, 2020

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 .

 

 

Translate
    zyuan15-Regular MemberAnswer
    5-Regular Member
    April 8, 2020

    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.

    Translate
      Constantine18-Opal
      18-Opal
      April 8, 2020

      Hello @rgurram,

       

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

       

      Regards,
      Constantine

      Translate
        slangleyCommunity Manager
        Support
        April 15, 2020

        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

        Translate
        Terms & ConditionsAccessibility statement