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

["Peter Burton" <Peter_Burton@hyperion.com>]

Murali,

mod -- Returns the fractional remainder, f, of x_value/ y_value such that 
x_value = i * y_value + f, where i is an integer, f has the same sign as 
x_value, and the absolute value of f is less than the absolute value of 
y_value. The arguments are promoted to the type of the greatest precision and 
the function returns
a value of that type.

Syntax: dst_var = mod(x_value, y_value)

● x_value = decimal, float, or integer literal, column, variable, or 
expression.
● y_value = decimal, float, or integer literal, column, variable, or 
expression.
● dst_var = decimal, float, or integer variable.

Example: let #fmodvar = mod(#fxvar, #fyvar) 


Peter

-----Original Message-----
From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org 
[mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org] On Behalf Of 
Kaithi, Murali
Sent: Thursday, January 05, 2006 1:54 PM
To: This list is for discussion about the SQR database reportinglanguage 
fromHyperion Solutions.
Subject: RE: [sqr-users] Rounding to the next whole number

Sudheer,
Thanks for your reply, 
I am not trying to print the result, after I divide the number, I just
want to investigate the result whether it is a whole number or not if
not get the next whole number.
How do I investigate the result number after dividing.

Thanks,
Murali 

-----Original Message-----
From: sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org
[mailto:sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org] On
Behalf Of Sudheer Bachu
Sent: Thursday, January 05, 2006 1:41 PM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Rounding to the next whole number

Hi murali,
         You can divide the number with any number and id it is an
amount edit the number while printing like  Your_final_print_variable =
edit(&calculated_number,'$$$,$$$,$$0' )  

Else it is just a number then use this

PRINT $ Your_final_print_variable     (0,+{col_sep},{col_amt})  edit 999

Thanks
Sudheer Bachu

-----Original Message-----
From: sqr-users-bounces+sbachu=creditacceptance.com@sqrug.org
[mailto:sqr-users-bounces+sbachu=creditacceptance.com@sqrug.org] On
Behalf Of Kaithi, Murali
Sent: Thursday, January 05, 2006 1:37 PM
To: This list is for discussion about the SQR database reporting
languagefromHyperion Solutions.
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

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

________________________________________________________________________
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



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