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
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
things value by value on calculating INT. I am getting a "non numeric
data when required" error. As soon as I get rid of INT, the I-descriptor
is capable of using value by value properly. There is no INTS (just like
there is a OCONVS etc). Does anyone know how to handle this in
multi-value fields?
Thanks again.
Laure Hansen,
City of Redwood City
Information Technology
www.redwoodcity.org
1017 Middlefield Road
Redwood City, CA 94063
Tel: 650-780-7087
Fax: 650-556-9204
[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jerry
Sent: Monday, March 26, 2007 12:21 PM
To: u2-users@listserver.u2ug.org
Subject: Re: 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 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 result will obviously be a
multi-value.
If the result is an integer, I want it as is. When it's not, I want it
rounded up to the nearest integer. The data must be examined value by
value. CONS and UNITS both are integers.
Thanks in advance!
Laure Hansen,
City of Redwood City
Information Technology
www.redwoodcity.org <http://www.redwoodcity.org/>
1017 Middlefield Road
Redwood City, CA 94063
Tel: 650-780-7087
Fax: 650-556-9204
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
