Sum totals
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21819
Printed Date: 05 May 2024 at 3:05pm
Topic: Sum totals
Posted By: looeej
Subject: Sum totals
Date 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?
Actual:
Part# Qty Lot
A 1 STR
A 2 ghi
A 4 LOP
Wanting this:
Part# Qty
A 7
TIA!
J
-------------
LooeeJ
|
Replies:
Posted By: kevlray
Date 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).
|
|