Hi John,
Faulding is good, we are owned by Mayne now.
Just as per Ken's example here is the UV equvilant
Top.
----:
0001: I
0002: mvfield.name;@NV
0003: MD0
0004: Count
0005: 3R
0006: M
0007:
----:
I could not get it to work without using good old pick conversions for EVAL.
EVAL "@RECORD<mvfld.no>" CONV "A;NV"
EVAL "OCONV('','F;mvfld.no;NV')
Regards,
Stewart
-----Original Message-----
From: John Kent [mailto:[EMAIL PROTECTED]
Sent: Friday, 2 April 2004 13:32
To: U2 Users Discussion List
Subject: Re: Running total
Stewart
try this, works for me in universe information flavour and on R83
1> D
2> 15
3> MV name
7> A;NV
9>R
10>5
from ye olde pick pocket guide version IV
NV returns the number of the mulit-value being processed
hows life at fauldings ?
jak
----- Original Message -----
From: "Mitchell, Stewart" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Friday, April 02, 2004 1:02 PM
Subject: RE: Running total
> Can you post the pick style dict, please.
>
> -----Original Message-----
> From: John Kent [mailto:[EMAIL PROTECTED]
> Sent: Friday, 2 April 2004 12:59
> To: U2 Users Discussion List
> Subject: Re: Running total
>
>
> Garth
> Thanks, but i was after something like
> an itemised list for each mv entry
> such as
>
> Field mv1 1
> mv2 2
> mv3 3
>
> Field mv1 1
> mv2 2
> etc
>
> ive only ever been able to do it as a pick style dict item or as a subr
>
> jak
> ----- Original Message -----
> From: "Garth Joubert" <[EMAIL PROTECTED]>
> To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
> Sent: Friday, April 02, 2004 11:52 AM
> Subject: RE: Running total
>
>
> Well the "quick and dirty" way is:
>
> LIST CUST EVAL "@1 + DCOUNT(CUST.NAME,@VM)" CUST.NAME
>
> Above assumes CUST.NAME is multivalued. Unfortunately the Counter only
> shows per row and not per multivalued, but again it is only a "quick and
> dirty".
>
> Hope this helps.
>
> -----Original Message-----
> From: John Kent [mailto:[EMAIL PROTECTED]
> Sent: Friday, 2 April 2004 2:07 p.m.
> To: U2 Users Discussion List
> Subject: Re: Running total
>
>
> Do you have anything for a multivalue counter with either an EVAL or
> ITYPE
>
> jak
> ----- Original Message -----
> From: "Garth Joubert" <[EMAIL PROTECTED]>
> To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
> Sent: Friday, April 02, 2004 7:49 AM
> Subject: RE: Running total
>
>
> Hi Ya,
>
> Quick way is to try:
>
> LIST CUST EVAL "@1+1" CUST.NAME
>
>
> (This might be dependant on Release Level)
>
> Wish you luck.
>
> -----Original Message-----
> From: Shrestha, Prabhash [mailto:[EMAIL PROTECTED]
> Sent: Friday, 2 April 2004 10:08 a.m.
> To: U2 Users Discussion List
> Subject: Running total
>
>
> Is there a way in UniQuery to create a virtual attribute that will print
> a running total of the number of items listed? For example:
>
>
>
> LIST CUST RUNNING_TOTAL CUST.NAME
>
>
>
> ID Running Customer
>
> Total.... Name.......
>
> 111 1 Joe Jones
>
> 112 2 Sue Smith
>
> 223 3 Sally White
>
>
>
> Thanks.
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
>
> --
> u2-users mailing list
> [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
> --
> u2-users mailing list
> [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
