Focal Point
how to 'summarize' in a row-total situation

This topic can be found at:

May 17, 2004, 04:51 PM
how to 'summarize' in a row-total situation
Does anybody know if a feature has been added , like "ROW-SUMMARIZE" ? Some way to recalcuate computed fields in row-total situation, the same way we use ON TABLE SUMMARIZE to correctly calculate our computed fields from a column. ?
(Other than , of course, doing all the stuff by arduous coding)
June 03, 2004, 08:57 PM
It has been requested as a New Feature, but not yet implemented.

June 04, 2004, 05:42 PM
<Jim Rich>
Coding is the only way currently. The way it was shown to me was to first do your request without any formatting and assign a sequence number (SEQ = 2), add BY SEQ NOPRINT and put it to a HOLD file. Then run your request again with a sequence number (SEQ = 1) and add BY SEQ NOPRINT. Include your formatting in this section. At the end use
to append the two files together. Aword of warning. if you use a COUNT or CNT. as one of your fields it does not work properly with a HOLD file. Use the following in a DEFINE
-*DEFCNT/I6 WITH fieldname = IF fieldname IS MISSING THEN 0 ELSE 1;
and then replace your fieldname in the request wtih DEFCNT in both sections. When SUMMED it will do the same as count and will work in the HOLD file.