Issue : Variable Decimal Rounding

[Former Member]

Hi Gurus,

I have the variable P_DATA with value 75468.275.

P_DATE is of type OIJ_ACTQTY.

I am doing an arthematic operation P_DATA = P_DATA / 10.

But the value of P_DATA is becoming 7546.828

I don't want rounding to happen.

QUESTION : How can we restrict Rounding ? I want value to be 7546.827.

Avi

[Former Member]

Hi

That means you want the result rounded off to default, so I think you need to store the result in a variable with 4 decimals and then move the rounded result in a variable with 3 decimals

Max

[kesavadas_thekkillath]

then move the rounded result in a variable with 3 decimals

Hi Max,

This will still round it.

A character variable of size 17 will be usefull

[kesavadas_thekkillath]

Its because OIJ_ACTQTY is of decimals 3 and cannot accomodate 4 decimals, so it rounds off.

data:p_data type OIJ_ACTQTY,
     p_p type p decimals 4,
     p_char type char17.
     p_data = '75468.275'.
     p_p = p_data / 10.   or   p_char = p_data / 10.

[roberto_vacca2]

Hi...

Pass your value to HR_ROUND_NUMBER.. If you use rounding type "space" you get your number without any rounding.. 10,556=> 10,55 for example leaving '6' alone

hope to help...

[roberto_vacca2]

...anyway there's also this function module ROUND

passing SIGN = space, you should gain your result..

[Former Member]

I guess there is a more elegant Version on how to do this, but following will work.

Make yourself a local variable wit decimals 4.

Now do your calculation into the new local variable.

Slope this local variable to another new variable of type char. Then you can tranfer it back to another char variable using offset.

Now you can transfer it back to your probably type p field.

[Former Member]

Question was asked before in forum and i gave sort of the same solution as now:

gv1 = '75468.275'.
write: / gv1.
gv1 = gv1 * 100.
gv1 = trunc( gv1 ).
gv1 = gv1 / 1000.
write: / gv1.

[kesavadas_thekkillath]

Thanks .... multiplying and truncating did the trick.

[Former Member]

>

> Thanks  .... multiplying and truncating did the trick.

Would expect a thanks from Avi.. but hey.. you're welcome!

[Former Member]

Take a variable of type f for calculation purpose and also take a variable type p with 3 decimal places.

For example.

I have the variable P_DATA with value 75468.275.

p_var1 type f.

p_var2(15) type p decimals 3.

p_var1 = p_data / 10.

Move value of variable p_var1 to p_var2.