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.
The table calculation option can still be used. Create a calculated field similar to the following:
zn(lookup(SUM([Shipped NO Tally Analysis].[Shipped]), 0))
Then, place is on the view and change it to Discrete.
Hope this helps!