I have 4 BY fields: Area, Dist, Repname & Rep ID. Since I want these to print on every line, I have made the BY fields invisible and then repeated them as SUM--MAX fields. (The rest of the fields are all SUM fields).

Question: Why does it repeat certain reps as if they were unique in some way?!

TABLE FILE KAREPDATA
SUM
'MAX.SEG01.AREA'
'MAX.SEG01.DIST'
'MAX.SEG01.REPNAME'
'MAX.SEG01.PRVDRID'
'RPT_UN_PRODLINE_BY_YR_FO.2006REG'
'RPT_UN_PRODLINE_BY_YR_FO.2006SMPL'
'RPT_UN_PRODLINE_BY_YR_FO.2006TOTAL'
'RPT_UN_PRODLINE_BY_YR_FO.2006GROSS'
'RPT_UN_PRODLINE_BY_YR_FO.2005REG'
'RPT_UN_PRODLINE_BY_YR_FO.2005SMPL'
'RPT_UN_PRODLINE_BY_YR_FO.2005TOTAL'
'RPT_UN_PRODLINE_BY_YR_FO.2005GROSS'

COMPUTE UNITGROWTH/D12 = ( 2006TOTAL - 2005TOTAL );
BY
'SEG01.AREA' NOPRINT
BY
'SEG01.DIST' NOPRINT
BY
'SEG01.REPNAME' NOPRINT
BY
'SEG01.PRVDRID' NOPRINT
HEADING
" "
"2006 data actually 2004 for testing"
WHERE ( RPT_UN_PRODLINE_BY_YR_FO.SALES_YEAR IN (2004,2005,2006) ) AND
( RPT_UN_PRODLINE_BY_YR_FO.REG_INVO_UN NE 0 ) OR
( RPT_UN_PRODLINE_BY_YR_FO.SMPL_INVO_UN NE 0 );
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K

(This is on 7.1)
Thanks!

MortEnob (or anagram of Trombone?)

There is an easier method of printing all the BY fields and that is by setting BYDISPLAY=ON.

As for the question, can you be a little more specific as we don't know your data as well as you?

Thanks, Tony! (Yup, Trom Bone
BY DISPLAY ON is a lot simpler, Derp.

Actually, this problem happens even with the BY fields visible, and it seems to revolve around the name field. When I removed my defined field, Repname, and used the raw Lastname data, it sorted and summed fine. However, when I added Firstname and MI (still raw data), even more reps are repeated. I am suspecting spaces vs. nulls in our files?
(The raw data contains numerous rows for each rep, and units data which is what I am summing.)
Thanks again for your help!
"Mort"