The ANINT function will round (up or down) a number to the nearest number, for example 2.5 will round up to 3, 2.49 will round to 2. If for some reason you want to round all decimal numbers up, 2.1 to 3, the you can use the following expression" SET VAR vrounded_up = (ANINT(.v_original + 0.4999)) This will round up any decimal number to the nearest higher number. 7.0 will remain 7 but 7.001 will become 8. I hope that this is of help.
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com]On Behalf Of Dan Goldberg Sent: Tuesday, November 05, 2002 12:15 PM To: Rbase-L Subject: FUNCTION TO ROUND UP Doe anybody know a function to round a number up. I have looked at the round functions but they only round to the closest number. Dan Goldberg ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
