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: [email protected] Subject: Re: Spam:[U2] Universe I-descriptor help INT((CONS / REUSE(UNITS)) + 0.5) ----- Original Message ----- From: "IT-Laure Hansen" <[EMAIL PROTECTED]> To: <[email protected]> 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 > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
