Table Visualization - Data Not Populating in Columns to the Right After Column = Blank

Hi all.

I've got a data display issue that I can't figure out how to fix. I've Googled and searched these forums and come up empty. Can someone please take a look?

The issue is with a table visualization. When I pull in just non-numerical columns that are all populated it works fine (displays the LT 1 Amount = $0, Issued Diff = $0, in this case Bank Amount truly is blank for the rows):

When I add the Statement Date column, if the value for the row = blank it does not return anything to the right, even if that column does contain a value (Explanation is now blank, even though the source data contains a value):

Order of columns seems to matter, if I switch the postion of Explanation and Statement Date the Explanation goes back to populating, but the Amount columns (LT 1 Amount and Issue Diff) are still blank, instead of the $0 I expect to see:

Moving Statement Date to the last column does not fix LT1 Amount and Issue Diff:

All non-numerical values do have "Show items with no data" selected (it's not an option for the numerical values):

This is what I want to see:

These are my relationships:

Any tips on how to fix this? 

Thanks!