Re: Spam:[U2] Universe I-descriptor help

2007-03-27 Thread Mats Carlid
But there is a !INTS - function. -- mats IT-Laure Hansen skrev: Thanks everyone for the formula. I should have waited until the caffeine kicked in. But I'm still having problems, and this I am guessing is strictly a Universe I-descriptor question. Looks like the system is not treating

Re: Spam:RE: Spam:[U2] Universe I-descriptor help

2007-03-27 Thread Jerry
Take the INT out of the calculation and put a conversion of MD0 in field 3 of the I-Descriptor. - Original Message - From: IT-Laure Hansen [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, March 26, 2007 2:59 PM Subject: Spam:RE: Spam:[U2] Universe I-descriptor help

[U2] UniVerse I-descriptor Help

2007-03-26 Thread Moderator
REPOSTED FOR NON-MEMBER: Laure Hansen [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Hello, I'm trying to avoid having to write a subroutine to, basically, always round up the result of a division between a multi-value field and a single-value one, in an I-descriptor (UV 10.1). My MV field is

RE: [U2] UniVerse I-descriptor Help

2007-03-26 Thread Norman Morgan
-Original Message- I'm trying to avoid having to write a subroutine to, basically, always round up the result of a division between a multi-value field and a single-value one, in an I-descriptor (UV 10.1). My MV field is named CONS, my single value one is names UNITS, the

Re: Spam:[U2] Universe I-descriptor help

2007-03-26 Thread Jerry
INT((CONS / REUSE(UNITS)) + 0.5) - Original Message - From: IT-Laure Hansen [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, March 26, 2007 1:00 PM Subject: Spam:[U2] Universe I-descriptor help Hello, I'm trying to avoid having to write a subroutine to, basically

Re: [U2] UniVerse I-descriptor Help

2007-03-26 Thread Mr somanshu baghel
i feel it should be INT(CONS/REUSE(UNITS)+ 0.5) Thanks, Somanshu Baghel - Original Message From: Norman Morgan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, March 26, 2007 11:52:25 PM Subject: RE: [U2] UniVerse I-descriptor Help -Original Message- I'm

RE: [U2] UniVerse I-descriptor Help

2007-03-26 Thread Norman Morgan
i feel it should be INT(CONS/REUSE(UNITS)+ 0.5) You are correct, of course. I rounded in the wrong place. === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === The Queue

[U2] Universe I-descriptor help

2007-03-26 Thread IT-Laure Hansen
Hello, I'm trying to avoid having to write a subroutine to, basically, always round up the result of a division between a multi-value field and a single-value one, in an I-descriptor (UV 10.1). My MV field is named CONS, my single value one is names UNITS, the formula is CONS / REUSE(UNITS). The

Re: [U2] Universe I-descriptor help

2007-03-26 Thread Richard A. Wilson
isnt there an iconvs oconvs SUBR routine ? I dont have manuals or pdf's available at the moment Rich IT-Laure Hansen wrote: Hello, I'm trying to avoid having to write a subroutine to, basically, always round up the result of a division between a multi-value field and a single-value one,

RE: [U2] UniVerse I-descriptor Help

2007-03-26 Thread Janke, Mark
Morgan Sent: Monday, March 26, 2007 3:34 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse I-descriptor Help i feel it should be INT(CONS/REUSE(UNITS)+ 0.5) You are correct, of course. I rounded in the wrong place. === Norman

RE: [U2] UniVerse I-descriptor Help

2007-03-26 Thread Ron Hutchings
: [U2] UniVerse I-descriptor Help Date: Mon, 26 Mar 2007 14:04:44 -0400 REPOSTED FOR NON-MEMBER: Laure Hansen [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Hello, I'm trying to avoid having to write a subroutine to, basically, always round up the result of a division

RE: Spam:[U2] Universe I-descriptor help

2007-03-26 Thread IT-Laure Hansen
: Spam:[U2] Universe I-descriptor help INT((CONS / REUSE(UNITS)) + 0.5) - Original Message - From: IT-Laure Hansen [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, March 26, 2007 1:00 PM Subject: Spam:[U2] Universe I-descriptor help Hello, I'm trying to avoid having

RE: [U2] UniVerse I-descriptor Help

2007-03-26 Thread IT-Laure Hansen
] On Behalf Of Janke, Mark Sent: Monday, March 26, 2007 1:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse I-descriptor Help Actually, I think you would need to use the REUSE function on the 0.5 also; otherwise the 0.5 will be added to only the first value in the intermediate result