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

Reply via email to