I have a database that requires inventory calculation. Deliveries are subtracted from production, obviously. But both deliveries and production must necessarily be Summary Fields. Because it is a calculation, I have used the GetSummary function. I want to eliminate items that have 0 quantity from the inventory report. A simple Find in the calculated field requesting >0 does not work, probably because even though it is a calculated field, it is really a summary field. I have tried self-joined tables on fancy calculations, If statements designed to produce 0 or 1, but nothing seems to work.
This should be so simple, but it has frustrated me for way too long.
Any ideas?