I have a report that needs to display the count of distinct primaryfolders in the subtotal line. However when I code this as I did below per examples I found online, I do not get the correct primaryfolders count, it is displaying a count of the documentname, not the primaryfolders . What am I missing here?

Can someone please give me a better example of HOW to display ONLY the distinct count of PRIMARYFOLDERs in the subtotal line. I ONLY want to display the count in the subtotal line, no count the report itself.
THANK U


TABLE FILE STORAGEDETAIL
PRINT
ANSWERSET1.PARENTFOLDER
ANSWERSET1.PRIMARYFOLDER
ANSWERSET1.DOCUMENTNAME
ANSWERSET1.TOTALMB
ANSWERSET1.CREATEDDTTM
ON TABLE HOLD AS HOLD1
END


TABLE FILE HOLD1
SUM
COMPUTE CNT1/I3 WITH PARENTFOLDER = CNT.DST.PRIMARYFOLDER; AS ''
DOCUMENTNAME AS 'Document Name'
TOTALMB/D20.4 AS 'MB'
CREATEDDTTM/HMDYY AS 'Created Date'
BY LOWEST PARENTFOLDER AS 'Folder Name'
BY LOWEST PRIMARYFOLDER AS 'Primary,Folder Name'
BY LOWEST DOCUMENTNAME NOPRINT
BY LOWEST CREATEDDTTM NOPRINT
ON CNT1 SUBTOTAL AS 'Subtotal'

This message has been edited. Last edited by: <Kathryn Henning>,

quote:

display the count of distinct primaryfolders in the subtotal line

the count of distinct primaryfolders within what? As it stands, it's within each sort-break of
PARENTFOLDER, PRIMARYFOLDER, DOCUMENTNAME, CREATEDDTTM
so it's =1 for each row, and on the subtotal or total lines it's effectively just a row count.

You probably need a two-verb request, along the lines of

sum cnt.dst.PRIMARYFOLDER

sum (or print) whatever
by whatever...
on table summarize

quote:

I ONLY want to display the count in the subtotal line, no count the report itself.

Once you get the numbers right, you can address rearranging the output (NOPRINT, SUBFOOT, ...).

I want the count of distinct rows with the hold file in the subtotal line. I don't want it within the sort break, i'll try what u suggested.
thanks

This does not work for me, I can get the correct count for the primaryfolder when no other fields are added. However when I add the additional fields, the numbers are incorrect since they are sorting by each field I assume. IS there a example somewhere I can look @ to see how this works, I'm somewhat new to this & its somewhat confusing.
thanks

I'm sorry, the count of primary folders WITHIN the PARENTFOLDER is what I needed. THis is what I need to display on the subtotal line

Then just add
by PARENTFOLDER
to the first verb:

sum cnt.dst.PRIMARYFOLDER
 by PARENTFOLDER 

sum (or print) whatever 
 by PARENTFOLDER 
 by whatever else...
on PARENTFOLDER subtotal
. . .

Thank you, I was able to get the results I needed.

Don't forget to mark the ticket [Solved] per the Forum instructions.