Subfiles and Subtotaling
Kogan, Arthur
akogan@westpac.com.au
Tue, 23 Mar 1999 11:26:24 +1100
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_000_01BE74C4.4F4E4376
Content-Type: text/plain
Hi Wanda,
are you using "report" or "footing at SORT1"?
Can you send the complete source.
Regards,
Arthur Kogan
Westpac Financial Services
Sydney, Australia
> -----Original Message-----
> From: Ravenscroft, Wanda L [SMTP:WandaL.Ravenscroft@Energizer.com]
> Sent: Tuesday, 23 March 1999 11:05 AM
> To: powerh-l@lists.swau.edu
> Subject: Subfiles and Subtotaling
>
> I have a subfile that I've created. Following is an example of some data
> that is in this subfile.
>
> SC Type PC AC Cost
>
> 412 30917 A 4010813
> 413 30917 A 9042253
> 413 30917 A 4386797
> 414 30917 A 5765510
> 415 30917 A 22749072
> 470 30917 A 7949987
>
> The first column is what we call sales class and the last column is a cost
> field. As you can see, the value of 413 in column 1 is reported twice. I
> want to subtotal on the last column and report the value of 413 only once.
> I should end up with:
>
> 413 30917 A 13429050
>
> When I report the cost column with the command subtotal on it, I get
>
> 413 30917 A 9042253
>
> Can anybody tell me what it is I might be doing wrong? I do have this
> working on another subfile and I don't appear to be doing anything
> differently, but one never knows the little things that can go awry when
> it
> comes to programming. In case my sort makes a difference, I have it
> defined
> as follows:
>
> Define SORT1 char*17 = Type + PC + ascii(SC)
>
> PC as you can see is a blank in this case.
>
> Any help that can be provided would be wonderful and very much
> appreciated.
>
> Wanda Ravenscroft
> Programmer Analyst
> Eveready Battery Company
> Open VMS 6.1, PH 7.10F1
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> 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.
------_=_NextPart_000_01BE74C4.4F4E4376
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+Ig0AAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQAdAAAAUkU6IFN1YmZpbGVzIGFuZCBTdWJ0b3RhbGluZwAt
CgEJgAEAIQAAADMyOUQ4QkFCQTRFMEQyMTE4ODRFMDAwMDgzNjgzNTY3APgGASCAAwAOAAAAzwcD
ABcACwAeAAoAAgAlAQEFgAMADgAAAM8HAwAXAAsAGgAYAAIALwEBDYAEAAIAAAACAAIAAQOQBgAk
CwAAKwAAAAsAAgABAAAAAwAuAAAAAABAADkAEIOXyMN0vgEeAHAAAQAAABkAAABTdWJmaWxlcyBh
bmQgU3VidG90YWxpbmcAAAAAAgFxAAEAAAAbAAAAAb50wUeg6iV6BuCnEdKeHgAA9rj6EQAAkTrA
AAIBCRABAAAAKQYAACUGAADBCgAATFpGdfK1UvMDAAoAcmNwZzEyNdIyAPszNgHoIAKkA+MJAgBj
aArAc2V0MB4gBxMCgwBQEFZwcnHeMhFZDlAD1RFlfQqACMjsIDsJbw4wNRV/CmACgNkKgXVjAFAL
A2MAQQtgIm4OEDAzMwumIEiIaSBXAHBkYSwKokcKhAqACsBlIHkIYCCmdQCQGTAgIhbgcAkRlCIg
BbEiAhBvdBwSAmEFQFNPUlQxIno/GrpDA5EbshEQGnAg7HRoG5AFoG0LUBEgG5AicwhhY2UuGrpS
ZXpnCxFzGqsHEB/QCHAgXEtvIfALkBrDVweQdLEKsGMgRguAAHBjBzE9BlJ2DeAHkBq0BrBkbphl
eSwRUBvwdHIHQP8HMBq6CvQnEA8xGMEBQBKgCx1ABZB0EeQxNiAttSoCTwUQZyTBAyBNB5Dwc2Fn
ZSoDGrYpFCjhgwsTKRZpLTE0NAFAcScQMTgwAUAM0C2jYiskoANhOgyDYhFAUmF2dgnwBPFvAYAm
kBpTIABMIFtTTVRQOkkaU0wuL8lARSZgctUqgHoEkC4gEV0atS7Q1wZgAjAvN1QKUHMagCaBHDIz
BdAKwBDQIDE5QzYQNfAxOjA1EVBNWTOHVG8vNxyAdwSQaJgtbEAnECRQcy4D4DhhdS4JgAxwM5d1
Yv5qKUEvNzoRLXAgUAQgGmH9OgJ0HUAnARkwK68suihmzxORE5IMARrDSSAQ4C/gnx2QH3A7JB/B
HaFJJ0ARzQUAZR2gCYAuICSgBvAfCQAD8BwhBAA7kSBleLZhIDIc0GYgkQeAIBqA/wGQGrRA40LB
C4AfwULBQGU3IQtCAAYAQ0cBNNB5cKsbkEdSUEdCQUdDIAhQGyRQRk00DiBHATMwOewxN0fTSsVB
R9MtwBlQfDgxGYBJmDWASl9LZjl4MDQyDjBMT01fS5QzoDg2Nzk3SYk0T+/xS1c1NzYWoBlQSYk2
kOdSz0tlTuA3NE6wAcBJiD43EUBVn0tmUcBXQDk4+1HlGrRUH+EtcBEABUAI4ex1bQOgQsF3QPI4
MCAA7wdAAyArEDtiYwtgBBE7on8f0l2hW6ow0AWgSQYtcGX6bEHiQQQgG7Jc4AOgERD2ZSaQH9J2
B0AKUEOST7L7RUFbxTFCshxkCYAfwAPweyDhQgBJGrQ5EAIwH8Bv/0BSPBMc0EVSXlw7ohxkYZ85
ZiFseWYhIOc/0HNoTwhgYFBDEB+hdXBcUGn/H9AvMEk+T99LR0wwTtBOsP41P2Uj1R/gA6A/0Gep
X4L/W7ZrIh/GA4EfsGWqazAmkP8/0CswSR9sf04PTxUeqABw+nkG4GRpUCBwXQFD8VxjV2swQrI/
0G0qcGgFQGK1RAFvHBJ3A2AZMD9kkd96IT/kRXJkxQWwaxwSZjF/AHAdQB/gBcBAZjuiexJu8icF
QGFwR7AKwWVxegfXd9FFcTx2ZAaQZgSQNCHzaUAmkGJ1BUACIBuQJmDrL+AFwGt9EHcEIF4zazC/
gVB7kxkwgsIdoWESZ2WA/mF6kGlQXGBvgWswGrQgEf8HkWVxKQEJwENAeaAZMGSC92LBXbAbkG1p
UCCgZ+EAwP5rO3JEEIDlIOBzMj/zeSF/AQELgAmAGxUEIAIQQkJz82trDIIgRIpDHcQgABDh6ip1
IT1HhCtIEo6AXbDpJQBpKEcwKRq6SCGLAe9g2V8kAmAAcGtFN4eCIQv+QXfgP+BgQGsAhAd6ASkB
/yWAAQAfsHxQanJ6AXxQGnC9BJBmanA7k4JBaVBtGED/NeB+wRbgJQFBwm6rMKMvyV+P5YaFfVGT
oAdAeUkGRfeCQUGgeCFCHaAgcIThCFC3IDB30Rq0T0ewA6BWBeHINi4xJpBQSFngnoD8MEYYYxr2
jhCgH6Evoj+/o0+jsyXVOiAE8noAOhxA/0BhpVQ4BxzARUEHgSsSefD3eBNlgADAagWwejAEYDif
7RrSVQCApTl1qkimf6eD/6gvOO44HzkkQrIh8CBwORB2eWQBgeEtsSF/I2swLvut8yVhLq82WsZC
wa3yQrL/XZBI8AmAYYIb8IYzcJJlcf+C5CRQJpAbspdAW5F6AUBDL6VUMyAatBSRALkAAAAAAwD9
P1IDAAAeAEIQAQAAADkAAAA8QzEzRERFNjdCOTYwRDIxMUJDRUMwMDAwRjg3QUMzQkY4NUU5QkRA
VVNIUUxNU0VYQ0hHMDAyPgAAAAALAACACCAGAAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAMAB4AI
IAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwAjgAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAAHQQ
AAAeACSACCAGAAAAAADAAAAAAAAARgAAAABUhQAAAQAAAAUAAAA4LjAyAAAAAAMAD4AIIAYAAAAA
AMAAAAAAAABGAAAAAAGFAAAAAAAACwApgAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADAAyA
CCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMAK4AIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAA
AAAAHgA6gAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAB4AO4AIIAYAAAAAAMAA
AAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeADyACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAA
AAEAAAAAAAAAAwAmAAAAAAADADYAAAAAAB4AMUABAAAADwAAAEtPR0FOQTREQ0I3ODM4AAADABpA
AAAAAB4AMEABAAAADwAAAEtPR0FOQTREQ0I3ODM4AAADABlAAAAAAAMAgBD/////AgH5PwEAAABi
AAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAABgAAAC9PPVdFU1RQQUMvT1U9V0JDL0NOPVJFQ0lQ
SUVOVFMvQ049TVNNQUlMIEFERFJFU1NFUy9DTj1LT0dBTkE0RENCNzgzOAAAAB4A+D8BAAAADgAA
AEtvZ2FuLCBBcnRodXIAAAAeADhAAQAAAA8AAABLT0dBTkE0RENCNzgzOAAAAgH7PwEAAABiAAAA
AAAAANynQMjAQhAatLkIACsv4YIBAAAABgAAAC9PPVdFU1RQQUMvT1U9V0JDL0NOPVJFQ0lQSUVO
VFMvQ049TVNNQUlMIEFERFJFU1NFUy9DTj1LT0dBTkE0RENCNzgzOAAAAB4A+j8BAAAADgAAAEtv
Z2FuLCBBcnRodXIAAAAeADlAAQAAAA8AAABLT0dBTkE0RENCNzgzOAAAQAAHMLCehozDdL4BQAAI
MHZDTk/EdL4BHgA9AAEAAAAFAAAAUkU6IAAAAAAeAB0OAQAAABkAAABTdWJmaWxlcyBhbmQgU3Vi
dG90YWxpbmcAAAAACwApAAAAAAALACMAAAAAAAMABhA4l1joAwAHENYFAAADABAQAAAAAAMAERAB
AAAAHgAIEAEAAABlAAAASElXQU5EQSxBUkVZT1VVU0lORyJSRVBPUlQiT1IiRk9PVElOR0FUU09S
VDEiP0NBTllPVVNFTkRUSEVDT01QTEVURVNPVVJDRVJFR0FSRFMsQVJUSFVSS09HQU5XRVNUUEFD
RgAAAABD+g==
------_=_NextPart_000_01BE74C4.4F4E4376--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.