[Robelle-l] $subtotal question

Eben Yong eben_yong@hpsm.org
Thu, 23 Oct 2003 12:20:46 -0700


This is a multi-part message in MIME format.

------_=_NextPart_001_01C3999A.C2862ECC
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: base64

SW4gc2hvcnQsIEknbSBjb25mdXNlZCBhbmQgd291bGQgYXBwcmVjaWF0ZSBhbnkvYWxsIGFzc2lz
dGFuY2UuDQoNCiANCg0KSGVyZSdzIHRoZSBzb3VyY2UgZmlsZToNCg0KIA0KDQo+Zm8gcjFlDQoN
CiAgICBGaWxlOiBSMUUuRUJFTi5BSUggICAgIChTRCBWZXJzaW9uIEIuMDAuMDApDQoNCiAgICAg
ICBFbnRyeTogICAgICAgICAgICAgICAgICAgICBPZmZzZXQNCg0KICAgICAgICAgIFlNREVGRi1Z
RUFSICAgICAgICAgIFg0ICAgICAgMQ0KDQogICAgICAgICAgTUVNQkVSIyAgICAgICAgICAgICAg
WDEyICAgICA1DQoNCiAgICAgICAgICBDTlQgICAgICAgICAgICAgICAgICBJMiAgICAgMTcNCg0K
ICAgIExpbWl0OiAzNTEzNSAgRU9GOiAzNTEzNSAgRW50cnkgTGVuZ3RoOiAyMCAgQmxvY2tpbmc6
IDY0DQoNCiANCg0KSWYgSSBydW4gdGhpcyBzaG9ydCBzY3JpcHQsIEkgZ2V0Og0KDQogDQoNCj5p
biByMWUNCg0KPmV4dCB5bWRlZmYteWVhcg0KDQo+c29yIHltZGVmZi15ZWFyDQoNCj5kdXAgbiBr
IGMNCg0KPmwgczt4DQoNCk9jdCAyMywgMjAwMyAxMjoxMyAgICAgICAgICAgICAgICAgIEZpbGU6
IFIxRQ0KUGFnZSAxICAgDQoNCiANCg0KWU1ERSBTVC1DT1VOVA0KDQogDQoNCjE5ODcgICAgICAg
ICAgOA0KDQoxOTg4ICAgICAgICAgNDINCg0KMTk4OSAgICAgICAgIDcwDQoNCjE5OTAgICAgICAg
ICA2Ng0KDQoxOTkxICAgICAgICAxMDINCg0KMTk5MiAgICAgICAgMTIxDQoNCjE5OTMgICAgICAg
IDMwNA0KDQoxOTk0ICAgICAgIDE3ODINCg0KMTk5NSAgICAgICAzNTQyDQoNCjE5OTYgICAgICAg
MzUxMA0KDQoxOTk3ICAgICAgIDMwMTUNCg0KMTk5OCAgICAgICAzMzg3DQoNCjE5OTkgICAgICAg
NDcwMg0KDQoyMDAwICAgICAgIDQ2NTANCg0KMjAwMSAgICAgICA0MTIxDQoNCjIwMDIgICAgICAg
MzYyMA0KDQoyMDAzICAgICAgIDIwOTMNCg0KSU49MzUxMzUsIFNFTD0zNTEzNSwgT1VUPTE3LiBD
UFUtU2VjPTEuIFdhbGwtU2VjPTEuDQoNCiANCg0KV2hhdCBJIHdhbnQgdG8gZG8gaXMgZmluZCBv
dXQgaG93IG1hbnkgZGlzdGluY3QgTUVNQkVSIyAgdmFsdWVzIGV4aXN0DQpmb3IgZWFjaCB2YWx1
ZSBvZiBZTURFRkYtWUVBUi4gIEluIG9yZGVyIHRvIGFjY29tcGxpc2ggdGhhdCwgSSBwbGFjZWQN
CnRoZSBDTlQgZGF0YSBlbGVtZW50IGluIHRoZSBmaXJzdCBmaWxlLCB3aGVyZSBpdCBpcyBhbHdh
eXMgZXF1YWwgdG8gMS4NCkkgdGhvdWdodCB0byB1c2UgdGhlICRzdWJ0b3RhbCBmdW5jdGlvbiB0
byBnaXZlIG1lIGEgY291bnQgb2YgaG93IG1hbnkNCnZhbHVlcyBleGlzdCBmb3IgZWFjaCBvY2N1
cnJlbmNlIG9mIFlNREVGRi1ZRUFSLCBidXQgaXQncyBub3QgZ2l2aW5nIG1lDQp3aGF0IEkgd2Fu
dC4gIEkgdHJpZWQgdGhlIGZvbGxvd2luZyB3aXRob3V0IHRoZSBkZXNpcmVkIHJlc3VsdDoNCg0K
IA0KDQppbiByMWUNCg0KZGVmIG1lbS1jbnQsMSwxNCxwYWNrZWQNCg0Kc29yIHltZGVmZi15ZWFy
DQoNCmV4dCB5bWRlZmYteWVhcg0KDQpleHQgbWVtLWNudCA9ICRzdWJ0b3RhbChjbnQseW1kZWZm
LXllYXIpDQoNCmR1cCBuIGsgYw0KDQpwdXJnZSByMWYsdGVtcA0KDQpvIHIxZix0ZW0sbGluDQoN
CngNCg0KIA0KDQpMaXN0aW5nIHRoZSBjb250ZW50cyBvZiByMWYgeWllbGRzIHRoaXMsIHdoZXJl
IHRoZSBNRU0tQ05UIGZpZWxkIGlzDQplc3NlbnRpYWxseSBtZWFuaW5nbGVzcy4gIA0KDQogDQoN
CllNREUgTUVNLUNOVCAgICAgICAgICAgICAgICAgICAgICBTVC1DT1VOVA0KDQogDQoNCjE5ODcg
ICAgICAgICAgICAgICAgICAgICAgICAgICAxICAgICAgICAgICA4DQoNCjE5ODggICAgICAgICAg
ICAgICAgICAgICAgICAgICAyICAgICAgICAgIDQyDQoNCjE5ODkgICAgICAgICAgICAgICAgICAg
ICAgICAgICAzICAgICAgICAgIDcwDQoNCjE5OTAgICAgICAgICAgICAgICAgICAgICAgICAgICA0
ICAgICAgICAgIDY2DQoNCjE5OTEgICAgICAgICAgICAgICAgICAgICAgICAgICA1ICAgICAgICAg
MTAyDQoNCjE5OTIgICAgICAgICAgICAgICAgICAgICAgICAgICA2ICAgICAgICAgMTIxDQoNCjE5
OTMgICAgICAgICAgICAgICAgICAgICAgICAgICA3ICAgICAgICAgMzA0DQoNCjE5OTQgICAgICAg
ICAgICAgICAgICAgICAgICAgICA4ICAgICAgICAxNzgyDQoNCjE5OTUgICAgICAgICAgICAgICAg
ICAgICAgICAgICA5ICAgICAgICAzNTQyDQoNCjE5OTYgICAgICAgICAgICAgICAgICAgICAgICAg
IDEwICAgICAgICAzNTEwDQoNCjE5OTcgICAgICAgICAgICAgICAgICAgICAgICAgIDExICAgICAg
ICAzMDE1DQoNCjE5OTggICAgICAgICAgICAgICAgICAgICAgICAgIDEyICAgICAgICAzMzg3DQoN
CjE5OTkgICAgICAgICAgICAgICAgICAgICAgICAgIDEzICAgICAgICA0NzAyDQoNCjIwMDAgICAg
ICAgICAgICAgICAgICAgICAgICAgIDE0ICAgICAgICA0NjUwDQoNCjIwMDEgICAgICAgICAgICAg
ICAgICAgICAgICAgIDE1ICAgICAgICA0MTIxDQoNCjIwMDIgICAgICAgICAgICAgICAgICAgICAg
ICAgIDE2ICAgICAgICAzNjIwDQoNCjIwMDMgICAgICAgICAgICAgICAgICAgICAgICAgIDE3ICAg
ICAgICAyMDkzDQoNCklOPTE3LCBPVVQ9MTcuIENQVS1TZWM9MS4gV2FsbC1TZWM9MS4NCg0KIA0K
DQpJIHJlYWxpemUgdGhhdCBhIG11bHRpLXBhc3MgZWZmb3J0IGlzIHJlcXVpcmVkIGFuZCB3b3Vs
ZCBhcHByZWNpYXRlIGFueQ0KaWRlYXMgb24gaG93IHRvIHNvbHZlIHRoaXMgcHJvYmxlbSB1c2lu
ZyBTVVBSVE9PTC4gIFRoYW5rcyENCg0KIA0KDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tDQoNCkViZW4gWW9uZw0KDQpNSVMgTWFuYWdlcg0KDQpIZWFsdGggUGxhbiBvZiBT
YW4gTWF0ZW8NCg0KNzAxIEdhdGV3YXkgQmx2ZA0KDQpTb3V0aCBTYW4gRnJhbmNpc2NvLCBDQSAg
OTQwODANCg0KVEVMOjY1MC02MTYtMjAxMA0KDQpGQVg6NzA3LTI4MS0yNjkxDQoNCnd3dy5ocHNt
Lm9yZw0KDQplYmVuX3lvbmdAaHBzbS5vcmcNCg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLSANCiAgDQpDT05GSURFTlRJQUxJVFkgTk9USUNFOiAgVGhpcyBlLW1haWwsIGlu
Y2x1ZGluZyBhdHRhY2htZW50cywgaXMgZm9yIHRoZSANCnNvbGUgdXNlIG9mIHRoZSBpbmRpdmlk
dWFsKHMpIHRvIHdob20gaXQgaXMgYWRkcmVzc2VkLCBhbmQgbWF5IGNvbnRhaW4gDQpjb25maWRl
bnRpYWwgYW5kIHByaXZpbGVnZWQgaW5mb3JtYXRpb24uIEFueSB1bmF1dGhvcml6ZWQgcmV2aWV3
LCB1c2UsIA0KZGlzY2xvc3VyZSwgZGlzdHJpYnV0aW9uLCBvciByZXByb2R1Y3Rpb24gaXMgcHJv
aGliaXRlZC4gSWYgeW91IGhhdmUgDQpyZWNlaXZlZCB0aGlzIGUtbWFpbCBpbiBlcnJvciwgcGxl
YXNlIG5vdGlmeSB0aGUgc2VuZGVyIGJ5IHJlcGx5IGUtbWFpbCANCmFuZCBkZXN0cm95IHRoaXMg
bWVzc2FnZSBhbmQgaXRzIGF0dGFjaG1lbnRzLiBUaGFuayB5b3UgZm9yIHlvdXIgDQpjb29wZXJh
dGlvbi4gIA0KIA0K

------_=_NextPart_001_01C3999A.C2862ECC
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<HTML xmlns:eXclaimer=3D"http://www.exclaimer.co.uk">
<HEAD>
<META http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3DUTF-16">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUTF-16">
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">

<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:r_ansi;
	panose-1:2 11 6 9 2 2 2 2 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{font-family:Arial;
	color:windowtext;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->
</style>

</HEAD><BODY lang=3DEN-US link=3Dblue vlink=3Dpurple><DIV>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>In short, I&#8217;m confused and would appreciate =
any/all assistance.</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Here&#8217;s the source file:</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>&gt;fo =
r1e</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>&nbsp;&nbsp;&nbsp; File:
R1E.EBEN.AIH&nbsp;&nbsp;&nbsp;&nbsp; (SD Version =
B.00.00)</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;
Entry:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Offset</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;
YMDEFF-YEAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
X4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;
MEMBER#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;
X12&nbsp;&nbsp;&nbsp;&nbsp; 5</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;
CNT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I2&nbsp;&nbsp;&nbsp;&nbsp;
17</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>&nbsp;&nbsp;&nbsp; Limit: =
35135&nbsp;
EOF: 35135&nbsp; Entry Length: 20&nbsp; Blocking: 64</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>If I run this short script, I get:</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>&gt;in =
r1e</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>&gt;ext =
ymdeff-year</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>&gt;sor =
ymdeff-year</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>&gt;dup n k =
c</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>&gt;l =
s;x</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font
 size=3D2 face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;font-family:r_ansi'>Oct 23,
 2003</span></font><font size=3D2 face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;
font-family:r_ansi'> </span></font><font size=3D2 face=3D"r_ansi"><span
 style=3D'font-size:10.0pt;font-family:r_ansi'>12:13</span></font><font =
size=3D2
face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;font-family:r_ansi'>&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;
File:
R1E&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Page 1&nbsp;&nbsp; </span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>&nbsp;</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>YMDE =
ST-COUNT</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>&nbsp;</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1987&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
8</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1988&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;
42</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1989&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;
70</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1990&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;
66</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1991&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;
102</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1992&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;
121</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1993&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;
304</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1994&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;
1782</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1995&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;
3542</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1996&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;
3510</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1997&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;
3015</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1998&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;
3387</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1999&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;
4702</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>2000&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;
4650</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>2001&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;
4121</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>2002&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;
3620</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>2003&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;
2093</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;
font-family:r_ansi'>IN=3D35135, SEL=3D35135, OUT=3D17. CPU-Sec=3D1. =
Wall-Sec=3D1.</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>What I want to do is find out how many distinct
MEMBER#&nbsp; values exist for each value of YMDEFF-YEAR.&nbsp; In order =
to
accomplish that, I placed the CNT data element in the first file, where =
it is
always equal to 1.&nbsp; I thought to use the $subtotal function to give =
me a
count of how many values exist for each occurrence of YMDEFF-YEAR, but =
it&#8217;s
not giving me what I want.&nbsp; I tried the following without the =
desired
result:</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'>in r1e</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'>def mem-cnt,1,14,packed</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'>sor ymdeff-year</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'>ext ymdeff-year</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'>ext mem-cnt =3D =
$subtotal(cnt,ymdeff-year)</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'>dup n k c</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'>purge r1f,temp</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'>o r1f,tem,lin</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'>x</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Listing the contents of r1f yields this, where the =
MEM-CNT
field is essentially meaningless.&nbsp; </span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
  style=3D'font-size:10.0pt;font-family:r_ansi'>YMDE
  =
MEM-CNT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  ST</span></font><font size=3D2 face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;
font-family:r_ansi'>-COUNT</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>&nbsp;</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1987&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
8</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1988&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
42</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1989&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
70</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1990&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
66</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1991&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 102</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1992&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 121</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1993&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 304</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1994&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1782</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1995&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3542</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1996&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3510</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1997&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3015</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1998&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3387</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>1999&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4702</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>2000&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4650</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>2001&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4121</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>2002&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
3620</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>2003&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2093</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi'>IN=3D17, OUT=3D17. =
CPU-Sec=3D1.
Wall-Sec=3D1.</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I realize that a multi-pass effort is required and =
would
appreciate any ideas on how to solve this problem using SUPRTOOL.&nbsp; =
Thanks!</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>-------------------------------------</span></font></p=
>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Eben Yong</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>MIS Manager</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Health Plan of </span></font><font size=3D2 =
face=3DArial><span
  style=3D'font-size:10.0pt;font-family:Arial'>San =
Mateo</span></font></p>

<p class=3DMsoNormal><font
  size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>701
  Gateway Blvd</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
  font-family:Arial'>South San Francisco</span></font><font size=3D2 =
face=3DArial><span
 style=3D'font-size:10.0pt;font-family:Arial'>, </span></font><font =
size=3D2
  face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>CA</span></font><font
 size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>&nbsp; </span></font><font
  size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>94080</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>TEL:650-616-2010</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>FAX:707-281-2691</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><a =
href=3D"http://www.hpsm.org">www.hpsm.org</a></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><a =
href=3D"mailto:eben_yong@hpsm.org">eben_yong@hpsm.org</a></span></font></=
p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>-------------------------------------</span></font></p=
>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;</span></font></p>

</div>

</DIV>
<DIV> </DIV>
<DIV>
<DIV>
<FONT SIZE=3D"2">CONFIDENTIALITY NOTICE:  This e-mail, including =
attachments, is for the</FONT><BR><FONT SIZE=3D"2">sole use of the =
individual(s) to whom it is addressed, and may contain</FONT><BR><FONT =
SIZE=3D"2">confidential and privileged information. Any unauthorized =
review, use,</FONT><BR><FONT SIZE=3D"2">disclosure, distribution, or =
reproduction is prohibited. If you have</FONT><BR><FONT =
SIZE=3D"2">received this e-mail in error, please notify the sender by =
reply e-mail</FONT><BR><FONT SIZE=3D"2">and destroy this message and its =
attachments. Thank you for your</FONT><BR><FONT SIZE=3D"2">cooperation. =
</FONT>
</DIV>
</DIV></BODY></HTML>

------_=_NextPart_001_01C3999A.C2862ECC--