AnsweredAssumed Answered

New user. Inventory List

Question asked by Gburg on Jun 29, 2009
Latest reply on Oct 28, 2009 by TSGal

Title

New user. Inventory List

Post

I am having trouble summarizing fields. We use an inventory list and need to summarize by lot number. My problem is that our warehouse may have the same lot number in 2-4 different rows and in order to get the total number of bags per lot number we have to look at each entry and add the rows together. Is there a way to summarize the inventory list to sort and give totals for lot numbers?

 

Example

 

Lot No.       Aisle Units 

4100            520

4100            520

                   TOTAL???? How do I get this number?

 

4200             300

4200             300

                   TOTAL???? How do I get this number?

Outcomes