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>,
WebFOCUS 7.6 Windows, All Outputs
February 25, 2015, 09:46 AM
j.gross
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, ...).
- Jack Gross WF through 8.1.05
February 25, 2015, 12:14 PM
nico
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
WebFOCUS 7.6 Windows, All Outputs
February 25, 2015, 12:37 PM
nico
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
WebFOCUS 7.6 Windows, All Outputs
February 25, 2015, 12:41 PM
nico
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
WebFOCUS 7.6 Windows, All Outputs
February 25, 2015, 03:56 PM
j.gross
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
. . .
- Jack Gross WF through 8.1.05
February 26, 2015, 10:43 AM
nico
Thank you, I was able to get the results I needed.
WebFOCUS 7.6 Windows, All Outputs
February 27, 2015, 09:38 AM
Kevin W
Don't forget to mark the ticket [Solved] per the Forum instructions.
WebFOCUS 7.7.05 (Someday 8) Windows 7, All Outputs In Focus since 1983.