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

Display Number/Integer 0 as blank in Infotable

  • April 6, 2020
  • 4 replies
  • 2148 views

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?

Best answer by zyuan1

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.

4 replies

V
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 .

 

 

    Z
    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.

      C
      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

        S
        slangleyCommunity Manager
        Community Manager
        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

        Terms & ConditionsCookie settingsAccessibility statement