2 Replies Latest reply on Feb 9, 2012 10:01 AM by Jeffrey Smith

    Mask 0 values as blanks

    Jeffrey Smith

      Is there a way to mask 0 values as blanks?

      Basically, 0s often visually clutter a table.

      When there is only one value field one can exclude/filter the 0s, but with multiple value fields that would filter the views for the other rows.

       

      Looks like this:

      Row HeaderMeasure Value 1Measure Value 2Measure Value 3Measure Value 4
      Dim1:Val1150230
      Dim1:Val232231411
      Dim1:Val30005
      Dim1:Val40400

       

      Want it to look like this:

      Row HeaderMeasure Value 1Measure Value 2Measure Value 3Measure Value 4
      Dim1:Val115
      23
      Dim1:Val232231411
      Dim1:Val3


      5
      Dim1:Val4
      4