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
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
porary 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
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 somet
CRT Z
CRT SUM(OCONVS(Z,'G1':@VM:1))
nb. It would seem logical to use FIELDS() function rather than use the G
conversion but - heh - FIELDS(), despite the documentation, doesn't work
using @VM as the separator.
Cheers,
--
Stuart
-Original Message-----
From: "George
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 of the dynamic array.
Can't say I can think of a single instance where this'd help me. It seems
to place an
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 n
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 of the dynamic array.
George
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] Behalf Of Bruce Nichol
>Sent: Wednesday, December 29