1 Reply Latest reply on May 10, 2013 4:27 PM by Tracy Rodgers

    Formatting NULL, discrete values in a text table

    bruce lomasky

      I have a discrete (so, can't use table calculation option) value from a joined data source in a text table.  (see "shipped" column in attached image.).  As you can see, the sum function is displaying nulls.  I do not see an option on the Format / Pane page to handle nulls.  I would like this to be either zero or blank.

       

      Thanks

       

      Bruce

      Screen Shot 2013-05-10 at 8.16.29 AM.png