topic Re: Problem in report. in Application Development and Automation Discussions

Problem in report.

Former Member — Mon, 12 May 2008 10:07:17 GMT

Hi friends,

I have a problem,

i have define box_no type i,

I_tab-BOX_NO = QUAN / 125000.

while dividing for eg:

300000/125000 = 2.4

but it display 2 .

if it is above .5 it display to

a approx value but if it is

below .5 it does not display

how can i display tthe values

2.4 to appox 3.

Re: Problem in report.

Former Member — Mon, 12 May 2008 10:12:11 GMT

Hi,

Try using ceil().

use FM ROUND.

Thanks,

Sriram Ponna.

Re: Problem in report.

former_member188827 — Mon, 12 May 2008 10:18:16 GMT

data: zp TYPE p DECIMALS 2, zint TYPE i.

zp = frac( 300000 / 125000 ).

zint = 300000 / 125000 .

IF zp is NOT INITIAL.

zint = zint + 1.

ENDIF.

WRITE zint.

u can also do as follows:

data zp type p decimals 0.

zp = ceil( 300000 / 125000 ).

replace da numbers wid ur variables..

plz reward points if dis helps

Re: Problem in report.

Former Member — Mon, 12 May 2008 10:20:43 GMT

it is like this becoz u have defined it integer ok

iif u want the output as u specified use

floor or seil key word

Cheers

Snehi Chouhan

Re: Problem in report.

Former Member — Mon, 12 May 2008 10:22:00 GMT

data : wsp1 type p DECIMALS 2,
         wsp type I.
        

  clear : wsp, wsp1.
  WSP = I_tab-BOX_NO.
  wsp1 = WSP - I_tab-BOX_NO.
  if wsp1 < 0.
    wsp = wsp + 1.
    ENDIF.

 I_tab-BOX_NO = wsp.

Re: Problem in report.

Former Member — Mon, 12 May 2008 10:25:11 GMT

This query is solved