Calculate open credit; avoid blank values

Hi,  I am trying to create an accounts receivables report and I want one list to show data about the amount of open credit of various customers, preferably in an area chart. My data look like this: ...