> 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/