topic Report Problem in Application Development and Automation Discussions

Report Problem

Former Member — Wed, 29 Nov 2006 07:34:39 GMT

Hi guys,

plz help me. in my report the out put coming like this

1234567.00

1354678.00

what i want in my output is 1230000.00

1300000.00

Thanks,

venkat

Re: Report Problem

Former Member — Wed, 29 Nov 2006 07:42:00 GMT

give me the exact problem if possible paste the code where the error is occuring

Re: Report Problem

Former Member — Wed, 29 Nov 2006 07:45:46 GMT

HI,

for 514395.97 i want 514000.00

for 888.00 i want 1000.00

for 17683.47 i want 18000.00

like that i want plz help me

thanks,

venkat

Re: Report Problem

Former Member — Wed, 29 Nov 2006 07:49:07 GMT

Try this:

DATA p_var TYPE p DECIMALS 2 VALUE '1223445.00'.
DATA p_var2 TYPE i.

p_var2 = p_var / 1000.
p_var = p_var2 * 1000.

WRITE p_var.

Re: Report Problem

Former Member — Wed, 29 Nov 2006 07:56:10 GMT

some additions

DATA p_var TYPE p DECIMALS 2 VALUE '1223445.00'.
DATA p_var2 TYPE i.
 
p_var2 = p_var / 1000.
p_var3 = p_var mod p_var.
if p_var3 LT 500.
p_var = p_var2 * 1000.
else if p_var3 GE 500.
p_var = p_var + 1.
p_var = p_var2 * 1000.
endif.

 
WRITE p_var.