Re: [sqr-users] Rounding to the next whole number

[JOHN_HARRIS@qvc.com]

You can use the ROUND function.  This will return a rounded value, rounded
to x decimals of precision.

Example:    LET #OLD_NUMBER = 36.5156
            LET #NEW_NUMBER = ROUND(#OLD_NUMBER,2)
Post execution value:   36.5200

Example:    LET #OLD_NUMBER = 36.5156
            LET #NEW_NUMBER = ROUND(#OLD_NUMBER,0)
Post execution value:   37.0000


                                                              
                                                              
 Thank you.                                                   
                                                              
 Regards,                                                     
                                                              
 John                                                         
                                                              
                                                              
                                                              
 (Embedded image moved    John Harris                         
 to file:                 Programmer/Analyst                  
 pic28703.jpg)            Application Development - Internal  
                                                              





QVC Inc., 1200 Wilson Drive, MC 220, West Chester, PA 19380-4262


Telephone 484-701-3303
Fax 484-701-8689
e-mail jharris@qvc.com



This message may contain information that is privileged or confidential.
This message may contain information that is privileged or confidential. If
you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein is STRICTLY PROHIBITED. If you received this transmission in error,
please immediately contact the sender and destroy the material in its
entirety, whether in electronic or hard copy format.


|---------+----------------------------------------------->
|         |           "Kaithi, Murali"                    |
|         |           <Murali.Kaithi@spencergifts.com>    |
|         |           Ext:                                |
|         |           Sent by:                            |
|         |           sqr-users-bounces+john_harris=qvc.co|
|         |           m@sqrug.org                         |
|         |                                               |
|         |                                               |
|         |           01/05/2006 01:37 PM                 |
|         |           Please respond to "This list is for |
|         |           discussion about the SQR database   |
|         |           reporting       language from       |
|         |           Hyperion Solutions."                |
|         |                                               |
|---------+----------------------------------------------->
  
>------------------------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                                 |
  |       To:       "This list is for discussion about the SQR database 
reporting languagefrom    Hyperion Solutions."           |
  |        <sqr-users@sqrug.org>                                                
                                                 |
  |       cc:       (bcc: JOHN HARRIS/QVC)                                      
                                                 |
  |       Subject:  [sqr-users] Rounding to the next whole number               
                                                 |
  
>------------------------------------------------------------------------------------------------------------------------------|




I have to divide a number by 10 and if the resulting number is not a
whole number, I have to Round up to the next whole number.
How can I accomplish this?
Appreciate your response.

Thanks,
Murali


________________________________________________________________________
This Email has been scanned for all viruses by PAETEC Email Scanning
Services, utilizing MessageLabs proprietary SkyScan infrastructure. For
more information on a proactive anti-virus service working around the
clock, around the globe, visit http://www.paetec.com.
________________________________________________________________________

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

Here was a non admissible message part of 'image/jpeg' MIME type. It
has been automatically discarded before sending the message to the
list. 
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users