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
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
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
-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
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
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
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
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
: [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
: 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
] 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
13 matches
Mail list logo