Re: Running Total- @1?

2004-04-02 Thread Allen Egerton
On Fri, 2 Apr 2004 14:54:14 -0800 , you wrote:

LIST CUST EVAL @1+1 CUST.NAME

Well OK, I'll 'fess up to being clueless... what is @1? Why does this work?
(running UV 9.6.1.3). What other @ variables are left out of my docs?

The most common use I've  found for @1, @2, etc are within very
complex I-Types, where statements are separated by semi-colons.  @1
refers to the determined value of the first statement, @2 to the
second, etc.

What follows is an off the cuff example, meant merely to demonstrate
the concept...

0 TAXABLE.YN
1 I
2 IF (STATE EQ CT MA RI) THEN 10 ELSE 0; IF (JOB.CODE EQ 12)
THEN 0 ELSE @1; IF (@2 GT 0) THEN Y ELSE N

-- 
Allen Egerton
[EMAIL PROTECTED]
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: Running total

2004-04-01 Thread Garth Joubert
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 RunningCustomer

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


RE: Running total

2004-04-01 Thread Roger Glenfield
Pick flavor possibility.
In your VOC.
create item named CNTR
1=A
2=9998
9=R
10=8 (or whatever you think your maximum would be.

SORT CUST CNTR CUST.NAME

By putting it in your VOC, it's available for all files.

Roger

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Behalf Of Garth Joubert
 Sent: Thursday, April 01, 2004 5:19 PM
 To: U2 Users Discussion List
 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 RunningCustomer
 
 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


Re: Running total

2004-04-01 Thread John Kent
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 RunningCustomer

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


RE: Running total

2004-04-01 Thread Garth Joubert
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 RunningCustomer

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


Re: Running total

2004-04-01 Thread Allen Egerton
On Thu, 1 Apr 2004 17:08:02 -0500, you wrote:

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 RunningCustomer

Total Name...

111   1  Joe Jones

112   2  Sue Smith

223   3  Sally White

In Universe, add a DICT item with the following fields:
0 LINE.NBR
1 I
2 @1 + 1
3 MD0
4
5 6R

Then LIST CUST LINE.NBR CUST.NAME  

-- 
Allen Egerton
[EMAIL PROTECTED]
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: Running total

2004-04-01 Thread Mitchell, Stewart
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 RunningCustomer

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


Re: Running total

2004-04-01 Thread John Kent
Stewart
try this, works for me in universe information flavour and on R83

1 D
2 15
3 MV name
7 A;NV
9R
 105

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 RunningCustomer

 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


Re: Running total

2004-04-01 Thread John Kent
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 @RECORDmvfld.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
 9R
  105

 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 RunningCustomer
 
  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


Re: Running total

2004-04-01 Thread John Kent
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 @RECORDmvfld.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
  9R
   105
 
  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 RunningCustomer
  
   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

RE: Running total

2004-04-01 Thread Mitchell, Stewart
John,

Try this for your itype

 SMM.CNT
0001 I  
0002 @RECORD11
0003 A;NV   
0004 Count  
0005 3R 
0006 M  

Stewart

-Original Message-
From: John Kent [mailto:[EMAIL PROTECTED]
Sent: Friday, 2 April 2004 15:14
To: U2 Users Discussion List
Subject: Re: Running total


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 @RECORDmvfld.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
  9R
   105
 
  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

Re: Running total

2004-04-01 Thread John Kent
Stewart,
that will do nicely
I can go home now

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


 John,

 Try this for your itype

  SMM.CNT
 0001 I
 0002 @RECORD11
 0003 A;NV
 0004 Count
 0005 3R
 0006 M

 Stewart

 -Original Message-
 From: John Kent [mailto:[EMAIL PROTECTED]
 Sent: Friday, 2 April 2004 15:14
 To: U2 Users Discussion List
 Subject: Re: Running total


 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 @RECORDmvfld.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
   9R
105
  
   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