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 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)) =========================================================== Norman Morgan <> [EMAIL PROTECTED] <> http://www.brake.com =========================================================== I still say a church steeple with a lightning rod on top shows a lack of confidence. =========================================================== ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ____________________________________________________________________________________ Need Mail bonding? Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users. http://answers.yahoo.com/dir/?link=list&sid=396546091 ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/