Mark The post said 'data file field'. In other words, summing a field across an entire file.
As for summing a specific variable: SUM(CONVERT(@VM:@SVM,@FM:@FM,Value)) Brian Did we not confuse this person with too much of an answer. He doesn't ask about the entire file so MQL is overkill. He doesn't ask about SQL so that may be overkill as well. He doesn't ask about the entire file so the READNEXT thing may also be overkill. Perhaps the answer is: * *** OPEN and READ <Any which way to OPEN and READ the REC of a file> * *** TO GET THE TOTAL OF THIS FIELD IF IT'S MULTI-VALUED TOT=SUM(REC<2>) * *** TO GET THE TOTAL OF THIS FIELD IF IT'S SUB-VALUED TOT=SUM(SUM(REC<2>)) If Marinko is new enough to MV to ask about SUM, then the other stuff may confuse him with things that he may believe are necessary. I'm answering his question as posted. It didn't imply the entire file. Just don't want to get the new people off on the wrong foot. Respectfully, Mark Johnson ----- Original Message ----- From: "Babic Marinko" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, March 07, 2007 10:04 AM Subject: [U2] SUM Function > Hi > > > > What is the best and fastest way to get the SUM of a specific numeric > data file field in UniVerse Basic? > > > > Kind regards, > > > > Marinko > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
