Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Supress Duplicate still sums all figures

Status
Not open for further replies.
Cpreston

Cpreston

MIS
Mar 4, 2015
987
GB
HI

I have a report that brings ion order numbers. Some order numbers may have more than one row but the total amount is always the same on each row.

I can supress the duplicate value so it just shows the one. But when I SUM the order it sum's all figures,

So if I have to rows at 8 it gives me 16, but I only want to see 8. I am grouping on

Ordernumber then Name and then subname. If I do not get rid of the duplicate SUM then the figures for all of them will be way out.

Any ideas how I can sum on just one.

THanks
 
Sort by date Sort by votes
Group by the order number, suppress the details (move all detail you need to the group footer). Create a running total for the total amount that only evaluates on change of group.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tlbrown88
  • Locked
  • Question
How to duplicate data from main report lines for sorting purposes
Replies
2
Views
411
lbass
lbass
CrystalBox
  • Locked
  • Question
Stop duplicate counts 1
Replies
2
Views
240
CrystalBox
CrystalBox
dgillz
  • Locked
  • Question
Dynamic parameter, but need option for ALL
Replies
1
Views
226
lbass
lbass
PremHealth1
  • Locked
  • Question
How do I drill into a report footer summary value to display all detail data?
Replies
5
Views
325
lbass
lbass
Beth_a_ny
  • Locked
  • Question
Supressing two groups
Replies
14
Views
562
Beth_a_ny
Beth_a_ny

Part and Inventory Search

Sponsor

Back
Top