Looking to Report on Currently Open Incidents

Looking for some assistance in tracking Open vs Closed Incidents, so I can run weekly reports on what is currently open and overdue. Below are the two weekly reports I have setup to capture these numbers, and the excel formula's I use to graph the data. I must be missing something here because I am getting negative results back, even tough both reports have the same filters. The only difference between these two reports is the Opened vs Closed logic in the Report Details.