Problem with Collection Statistics

[Brian Reilly]

Collection Statistics and other reports on my collection show what I believe to be correct numbers for every category except the "Between $10 and $24.99". In that category it shows that I own every issue of every comic; all 49 million+ issues worth $514 million and change (I wish).

I'm on Comicbase verion: v 21.0.1.1456.

Anybody have any idea what's going on here and how I can fix?

Thanks for any suggestions.

[Gregory Hecht]

Have you checked to see if any of your comics has an unusual quantity in stock?  For example, if you have ever accidentally entered a UPC code into the issue quantity field, you might get a result like this.  (not that such has ever happened to me, of course 😉 )

[Brian Reilly]

Intriguing idea Gregory but note how the snapshot shows that I have 10, 355 unique issues. I believe that to be the correct size of my collection. So, it seems the program knows I have that many issues but for some reason is not reflecting it correctly in the one "Value Range" row.

If I did want to investigate your suggestion, any idea how to easily find an individual issue with an improbably high quantity count?

[Gregory Hecht]

If you have a copy of Fantastic Four #1 in your collection and then you add a second copy of FF #1, that will change your count of total issues but NOT your count of unique issues (you already had a copy of FF #1 before you acquired the second copy).  So I think that your problem really is that at least one issue in your collection has an unusual number entered into the Quantity In Stock field.  

• To find the issues with an excess quantity, do the following:
• Go to any Comic Book title (not a Book or Magazine title).  Click on "Find" and select "Other"
• You should now have a small pop-up window.  Use the "Find" pull-down menu to select "Item Fields" and then select "Qty In Stock"
• After you do that, you should be able to select the "is greater than" option.  
• Type 1 in the text box, then click the "Find" button in the lower right corner.  

[Brian Reilly]

Gregory, you da man! Thanks for pointing me in the right direction.

Before I saw your latest reply, I exported to Excel and found the offending issue that way.

 

All appears to be fixed now.

[Gregory Hecht]

That's a lot of Lego!  Bet you could build something really cool with 49,003,621 Lego pieces!