Hi,
I hope someone can help with this.
I have a warehouse entry table that records the Quantity of Lots by Item and Bin. For a given Bin, I want to return the Lot No. where ther sum of the Quantity field is greater than zero. There may be more than one Lot in the Bin at any given time.
In the attached example, I want to return Lot 26489291
Date
Votes
1 comment
-
Jet Reports Historic Posts Are you looking for just the "Lot No." to be returned? If so, use the NL function like the following:
=NL("Rows","<<table name>>","Lot No.","Bin Code","EAS07","Quantity",">0",)
That filter will return a list of all the "Lot No." within the "EAS07" bin, and only those that have a quantity greater than 0.
You can even add more filters to return only specific item numbers too.
Let me know if this gives you what you're looking for, or if you need another result.
Thanks,
Scott
Hammond, Indiana
Please sign in to leave a comment.