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

    Format Null Fields

    Anu Rekha

      Hi All




      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