variable and SUM on it.
Rex
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of George Gallen
Sent: Wednesday, December 29, 2004 5:40 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] sum vs looping
What is needed is a VSUM() command, or vertical sum
Thanks,
I have something similar, although not as detailed.
George
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Rex Gozar
Sent: Thursday, December 30, 2004 9:19 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] sum vs looping
George,
I have
I tried the FIELDS before, but never tried the OCONV method.
Intresting...
George,
'Vertical' summation can be achieved by using vector OCONVS with a G
conversion. eg to sum the 2nd value from an attribute delimited dynamic
array : SUM(OCONVS(Z,'G1':@VM:1))
nb. It would seem logical to use
What is needed is a VSUM() command, or vertical sum.
Say X=VSUM(YDATA,2) and it will add up all the numbers
vertically that are in x,2 of the dynamic array.
George
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bruce Nichol
Sent: Wednesday, December
I believe you'll need to write that one yourself.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of George Gallen
Sent: Wednesday, December 29, 2004 3:40 PM
To: u2-users@listserver.u2ug.org
Subject: [Norton AntiSpam] RE: [U2] sum vs looping
What is needed
Goo'day, George,
At 17:39 29/12/04 -0500, you wrote:
What is needed is a VSUM() command, or vertical sum.
Say X=VSUM(YDATA,2) and it will add up all the numbers
vertically that are in x,2 of the dynamic array.
Can't say I can think of a single instance where this'd help me. It seems
to place
I think George Was viewing it for other uses of dynamic arrays other than
database records.
Dynamic arrays are quite often used for building a matrix of run time totals
or to build something similar to a data warehouse cube where you want to
total the values from different dimensions. Think