You are also going to need the INT function that operates on multi-values,
!INTS.
______________________________________________________________
From: Moderator <[EMAIL PROTECTED]>
Reply-To: [email protected]
To: [email protected]
Subject: [U2] UniVerse I-descriptor Help
Date: Mon, 26 Mar 2007 14:04:44 -0400
REPOSTED FOR NON-MEMBER: Laure Hansen <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>
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/
_________________________________________________________________
Watch free concerts with Pink, Rod Stewart, Oasis and more. Visit MSN
Presents today.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/