Joined: 25 Jun 2015
Location: United States
Online Status: Offline
Posts: 8
Topic: Sum totals Posted: 17 Dec 2015 at 6:40pm
I have an inventory report that I want to run totals for the inventory. I have materials that have unique lot numbers. My report could have the the same part number 3X because my inventory has 3 lot numbers. With that said I can have 1 , 2 and 4 as quantities for the 3 lines of the same part number. How can I sum the actual inventory count (1, 2 and 4) to be 7 for the 3 lines of duplicate part numbers?
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 18 Dec 2015 at 5:03am
Have you tried a running total? Basically sum of Qty, reset on change of Part#. In most cases you would want to group on Part#, and put the running total in the Group Footer (reset on change of group).
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum