Ignore lot number

Hi all,

I’d like a BAQ that shows the OnHand Qty for a bin ignoring the lot numbers or is the sum of On Hand Qty for all lot numbers.
E.g. in my case for Bin 0M0D I want to see OnHand Qty = 251.


A simple BAQ of the PartBin table can provide that.
Add a calc field of type decimal, with the formula


All other displayed fields will have to have their Group By box checked.