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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crosstab - Average on distinct records

Status
Not open for further replies.
mcgim1

mcgim1

MIS
Jul 1, 2002
12
NZ
Hi,

I have a crosstab that has 3 summaries
1 : Distinct count of records based on id number
2 : Sum of Amount for ALL records
3 : Average Amount

My problem is I want the average to be Amount/DistinctCount however it is going Amount/TotalNumberofRecords

Any ideas??
 
Sort by date Sort by votes
I have the same problem... So it's about time this question got resurrected !

;-)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Corinne30
  • Locked
  • Question
Duplex Printing of Postcard reminders - Not printing back on last page.
Replies
1
Views
139
hilfy
hilfy
petejigsaw
  • Locked
  • Question
Suppress group if it contains both specified detail records
Replies
3
Views
108
lbass
lbass
Betty Boop
  • Locked
  • Question
Report Shows Fewer Records After Grouping
Replies
5
Views
109
lbass
lbass
dellguy
  • Locked
  • Question
Possible to show multiple text values in crosstab as summarized fields
Replies
2
Views
97
dellguy
dellguy
sofseattle
  • Locked
  • Question
How to create value/page break for distinct number of records
Replies
9
Views
113
sofseattle
sofseattle

Part and Inventory Search

Sponsor

Back
Top