How to count null records in a bucket group

[Michael Perkins]

I am using PA Buckets to capture dollar ranges that come from another table.  The count of records below show 10 on the left but when they are bucketed the total is seven.  The three that are missing have no dollar records to sum.  I have configured null to register as 0, which are seen below in the Total Incurred column. 

This is a problem because the dashboard landing page shows closed records for yesterday (10) but the score widgets by bucket sum to seven. This is an executive level dashboard.  Confidence is lost when simple things don't add correctly.

Is there a way to make these balance without adding a a dummy zero record?  Adding a dummy record creates other problems.

Thanks,

Mike

[sizzleMcFace]

Have the original table's field default to 0. Whenever it would be empty, it should be 0 instead.

You can also set the "Value for unmatched" on the Breakdown, although that might not have the desired result.