Stewart,
    thanks,  i agree with the D version but do not get the I type to work as
you suggest

can you confirm
LIST CUSTOMER SMM.CNT SMM.ICNT
displays the same data?

I would really like the itype work so i can reuse a static field to get an
incrementing date against each mv

jak
----- Original Message ----- 
From: "Mitchell, Stewart" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Friday, April 02, 2004 2:34 PM
Subject: RE: Running total


> John,
>
> I got the same result as you in HS.SALES
> However, this worked in HS.SALES against the customer file field 11 is the
> product id field.
>
> >CT DICT CUSTOMER SMM.CNT
>
>      SMM.DCNT
> 0001 D
> 0002 11
> 0003 A;NV
> 0004 Count
> 0005 3R
> 0006 M
>
>      SMM.ICNT
> 0001 I
> 0002 OCONV(PRODID,'A;NV')
> 0003 MD0
> 0004 Count
> 0005 3R
> 0006 M
>
> it is still using  pick conversion but they are valid conversions in D & I
> type dictionaries.
>
> Stewart
>
>
> -----Original Message-----
> From: John Kent [mailto:[EMAIL PROTECTED]
> Sent: Friday, 2 April 2004 14:19
> To: U2 Users Discussion List
> Subject: Re: Running total
>
>
> 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
> -- 
> 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

Reply via email to