10-05-2007 2:23 PM
hi all,
I am trying to round of somes balances to without decimal places.
1) my value is 55.12
I need the value should be 55
or
1) my value is 55.65
i need the value should be 56
if the value is >.5 it should be 1
if the value is <.5 it should be 0
Please let me know how to do this
Thanks in advance.
RAM
10-05-2007 2:25 PM
10-05-2007 2:27 PM
10-05-2007 2:28 PM
Hi
Check the following MATHS functions
following maths functionas are there in SAP:
abs -Absolute value of the argument arg
sign- Plus/minus sign of the argument arg: -1, if the value of arg is negative; 0 if the value of arg is 0; 1 if the value of arg is positive.
ceil -Smallest integer number that is not smaller than the value of the argument arg.
floor- Largest integer number that is not larger than the value of the argument arg.
trunc- Value of the integer part of the argument arg
frac- Value of the decimal places of the argument arg
acos -Arcuscosinus [-1,1]
asin- Arcussinus [-1,1]
atan- Arcustangens
cos- Cosinus
sin- Sinus
tan- Tangens
cosh- Hyperbelcosinus
sinh -Hyperbelsinus
tanh -Hyperbeltangens
exp -Exponential function for basis e [-709, 710]
log -Natural logarithm > 0
log10 -Logarithm for basis 10 > 0
sqrt -Square root
May be ROUND/CEIL serve your purpose
Regards
Anji