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

[Roger.Harris@certegy.com]

Try this

Let #result = Ceil(#value / 10)



|---------+---------------------------------------------------->
|         |           "Kaithi, Murali"                         |
|         |           <Murali.Kaithi@spencergifts.com>         |
|         |           Sent by:                                 |
|         |           sqr-users-bounces+roger.harris=certegy.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:                                                                  
                 |
  |        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








------------------------------------------------------------------------------
This message contains information from Certegy, Inc which may be confidential 
and privileged.  If you are not an intended recipient, please refrain from any 
disclosure, copying, distribution or use of this information and note that such 
actions are prohibited.  If you have received this transmission in error, 
please notify by e:mail postmaster@certegy.com.
==============================================================================


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