No subject

[Watt, Peter]

Wanda,

What columns of the report correspond to what fields listed in the report
summary statement?  Also, not sure but the 'set noduplicates' may be causing
the problem.  Try commenting it out.

Regards,
Peter Watt



	-----Original Message-----
	From:	Ravenscroft, Wanda L [SMTP:WandaL.Ravenscroft@Energizer.com]
	Sent:	Tuesday, March 23, 1999 1:47 PM
	To:	'powerh-l@lists.swau.edu'
	Subject:	

	Thanks to all of you who responded to my plea for help.  I've poured
over
	the manual and I've tried all the suggestions sent to me and I'm
pretty much
	getting the same results as before.  Somebody had asked if it was
possible
	to get a copy of the source, here's the most current source with the
results
	received below that.  I'm sure it's something small that is getting
by me,
	but for the life of me, I can't see it.  Thanks again for any help
received.


	set save clear
	cancel clear

	set report nolimit

	access *wmfast1 alias wmf

	set noduplicates

	sort on pm_prdtyp, pm_pc, sc2

	report summary
&
	        sc2
&
	        pm_prdtyp of wmf
&
	        pm_pc of wmf
&
	        pm_asst_code of wmf
&
	        cvnc subtotal

	set subfile name wmfast2 at sc2 keep



	   412   30917            A     4010813
	   413   30917            A     4386797
	   414   30917            A     5765510
	   415   30917            A    22749072
	   470   30917            A     7949987



	On the line starting with 413, I should be getting:

		413   30917            A    13429050

	which would be the total of:

		413   30917            A     9042253
		413   30917            A     4386797


	= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
= = = =
	Subscribe: "subscribe powerh-l" in message body to
majordomo@lists.swau.edu
	Unsubscribe: "unsubscribe powerh-l" in message to
majordomo@lists.swau.edu
	powerh-l@lists.swau.edu is gatewayed one-way to
bit.listserv.powerh-l
	This list is closed, thus to post to the list, you must be a
subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.