Count of Total Number of Rows

[insipid1991]

I am a user just returning to WebFOCUS after being away for 3 years, so please bear with me.

I need help with getting a number of the total rows that are returned in a report.

This is my current method:

TABLE FILE EMPLOYEE
PRINT LAST_NAME FIRST_NAME HIRE_DATE
COMPUTE COUNTER/I6=1;
BY DEPARTMENT
ON TABLE COLUMN-TOTAL COUNTER

END

The problem with this method is I have a column at the end of my report with nothing but 1's in it and then a total at the bottom of the report. What I'd like to do is just have a row that says TOTAL = N and not have to create another column for that. See below:

FINANCE
BROWN JOHN 1/1/2002
JONES MARION 2/1/1989
MOON MARY 5/9/1994
SMITH HOWARD 10/5/1972

MIS
ALLEN BARRY 2/28/1995
FOWLER IAN 11/11/1999
SANDY KATHY 7/30/1995

TOTAL = 7


Any ideas?

Thanks!



Doug

 

[craigiep]

Try

TABLE FILE EMPLOYEE
PRINT LAST_NAME FIRST_NAME HIRE_DATE
COMPUTE COUNTER/I6=1; NOPRINT
BY DEPARTMENT
ON TABLE SUBFOOT
"TOTAL <ST.COUNTER"
END

 

[insipid1991]

Perfect! Thanks so much!


Doug