sum(sum()) ?   How about summation() 

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming
Sent: March 7, 2007 8:50 PM
To: [email protected]
Subject: Re: [U2] SUM Function

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/

Reply via email to