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

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

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

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