Whoops - forgot the reuse function:
LIST MY.FILE EVAL "SUM(GTS(MY.MV.FIELD,REUSE(0)))"
eg
LIST GRTRANS EVAL "SUM(GTS(REC.QTY,REUSE(0)))" FMT "10R" REC.QTY
G3878180 1 1
G4678192 1 2
1867500 4 1
4
6
1
G4078183 2 3
3
...
Stuart Boydell
-----Original Message-----
Hi all,
Using UniVerse 9.6 on AIX4.1,
I'm trying to write a routine to count the number of occurrences of
values > than 0, for example,
against this attribute:
0011: 4|0|0|0}4|23|4|0
I'd like to return a value of '4' for the 4 values > 0.
Not having much luck with COUNT or DCOUNT.
Any help is greatly appreciated.
Ed Hess
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
******************************************************************************************************
This email message and any files transmitted with it are confidential and
intended solely for the use of addressed recipient(s). If you have received
this communication in error, please reply to this e-mail to notify the sender
of its incorrect delivery and then delete it and your reply. It is your
responsibility to check this email and any attachments for viruses and defects
before opening or sending them on. Spotless collects information about you to
provide and market our services. For information about use, disclosure and
access, see our privacy policy at http://www.spotless.com.au
Please consider our environment before printing this email.
******************************************************************************************************
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
