Re: Running Total- @1?
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
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
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
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
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
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
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
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
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
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
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
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