Bingo! Perfect. Thanks very much. 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 Janke, Mark Sent: Monday, March 26, 2007 1:28 PM To: [email protected] 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 of CONS/REUSE(UNITS). INT(CONS/REUSE(UNITS)+REUSE(0.5)) However, on the old version of UniVerse I'm using, the INT function does not work with a multivalued argument and gives an error message. What I would use instead is the OCONVS function, which is the multivalued version of OCONV: OCONVS(CONS/REUSE(UNITS)+REUSE(0.5),'MD0') Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Norman Morgan Sent: Monday, March 26, 2007 3:34 PM To: [email protected] 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 Morgan <> [EMAIL PROTECTED] <> http://www.brake.com =========================================================== The Queue Principle: The longer you wait in line, the greater The likelihood that you are standing in the wrong line. =========================================================== > -----Original Message----- > > > -----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 > > formula is CONS / REUSE(UNITS). The result will obviously be a > > multi-value. > > I don't know Universe I-descriptors, but can you say > INT((CONS + 0.5) / > REUSE(UNITS)) ------- 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/
