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
