-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
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
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
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,
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
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:
] 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
