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,

RE: [U2] UniVerse I-descriptor Help

2007-03-26 Thread IT-Laure Hansen
Morgan Sent: Monday, March 26, 2007 11:22 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse I-descriptor Help > -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-

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

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

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, i

RE: [U2] UniVerse I-descriptor Help

2007-03-26 Thread Janke, Mark
ehalf Of Norman 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.

RE: [U2] UniVerse I-descriptor Help

2007-03-26 Thread Ron Hutchings
You are also going to need the INT function that operates on multi-values, !INTS. __ From: Moderator <[EMAIL PROTECTED]> Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject:

RE: [U2] UniVerse I-descriptor Help

2007-03-26 Thread IT-Laure Hansen
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 of