To clarify, row 0120 shows ‘0’ in the result because I have no account in data source. 0125 is still blank because I have account 40000 selected. Need 0125 to show ‘0’

Hello @jhouser ,

Hide Zero setting in Row and/or Column controls whether you see null or ‘0’. Have you already checked this setting?

Laura

Another option would be to set your format to #.##0.00 which will show a zero or a number.  This is typically placed in your column set rather than your row set for better control. 

Why #.##0.00?

• # placeholders are used for optional digits. They display a digit if it is present, but do not display extra zeros if the digit is not there.
• 0 placeholders ensure that a digit is always displayed, even if it's a zero. This is useful for ensuring consistent decimal places.

@Laura02 My understanding/experience is that Hide Zero checkbox will hide row if the result is 0. That’s not what we’re looking for. We want empty results (no activity for period, so blank result) to show a ‘0’. But please correct me if I’m wrong. :) 

@Robert Sternberg Thanks for your help!