Nice. Marc Rutherford Senior Programmer/Analyst Advanced Bionics LLC 661) 362 1754
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Boydell, Stuart Sent: Wednesday, January 06, 2010 3:13 PM To: U2 Users List Subject: Re: [U2] Count question 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 [email protected] 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
