I’ve created a report that groups Inventory Items so that I can sum Qty Produced for each item over a given time frame. The goal is to have a column for Inventory ID/Description, a Qty Produced Goal Column, and an Over and Under Column for the sum/difference where an item was over or underproduced where even if the item has not been produced, it would still show on the report.
For instance, no CHOC400 had been produced, it would still appear on the report, where:
Goal = 700
Qty Produced = 0
Instead the report is only showing if the item has been produced. So, for example, an inventory ID, CHOC400 which has not been produced this month, isn’t showing at all. How can I fix this?
I’ve attached a copy of the .rpx version of the report that’s saved as .doc so I could upload it.