I'm using the Filter Values options and selecting Does Not Equal. I'm inserting 0 for the answer to that Does Not Equal question. Yet some Lots with zero on-hands are still visible. I expanded one and found this:
Quantity Received: 248
Quantity Invoiced: -248.45
Inventory Adjustment: .45
The net of those three transactions is zero. So, not sure why it is still visible on the report.
You might try the forums at Mr. Excel - they are the absolute gurus as Excel functionality.
Thanks for the lead. I'll try them next.
Choose a location