3 Replies Latest reply on Jul 27, 2016 9:39 PM by Ashish Chaudhari

    Format Null Fields

    Anu Rekha

      Hi All

       

      Greetings!

       

      I am trying to format a numeric field, It has positive and negative values and Nulls..

      I have to suppress Nulls, I used the following custom format

       

      #,##0.0%; -#,##0.0%;""

       

      The positive and negative numbers are coming good and nulls are also getting suppressed.

       

      But when it has a value 0.0 it is also coming as " ".

       

      Please help if you have a better idea.

       

      Thanks and Regards

      Anu