Stewart,
tried that and all i get is the entry of 1 beside each multivalue
instead of incrementing mv numbers.
I am wondering if this is a information flavour thing.
Tried it in HS.SALES and its the same problem
The EVAL works though but its still the pick solution
jak
----- Original Message -----
From: "Mitchell, Stewart" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Friday, April 02, 2004 2:04 PM
Subject: RE: Running total
> 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
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users