topic Re: Sum in write statement / Urgent in Application Development and Automation Discussions

Sum in write statement / Urgent

Former Member — Fri, 07 Dec 2007 05:33:05 GMT

hi all ,

i have some fields in write statement o/p like NETWR , MWSBP... and i want to

take total (Sum of all NETWR & MWSBP) net value at end of output coloum..

how can i do in write statement.??

exa : NETWR MWSBP

100.00 25.00

50.00 10.00

can anybody help me its urgent .

regards saurabh .

Re: Sum in write statement / Urgent

Former Member — Fri, 07 Dec 2007 05:40:52 GMT

Hi use SUM, inside the loop.

Loop at itab.

at end of vbeln.

sum.

endat.

endloop.

data: tot_netwr type netwr.

loop at itab.

tot_netwr = tot_netwr + itab-netwr.

endloop.

write : / tot_netwr.

Re: Sum in write statement / Urgent

former_member386202 — Fri, 07 Dec 2007 05:41:18 GMT

Hi,

Use control statement

Loop at itab.

at last.

sum.

write 😕

endloop.

Reagrds,

Prashant

Re: Sum in write statement / Urgent

Former Member — Fri, 07 Dec 2007 05:42:26 GMT

Hi,

I hopr the example code below will help you:

DATA: BEGIN OF LUGGAGE,

AVERAGE TYPE P DECIMALS 2,

SUM TYPE P DECIMALS 2,

END OF LUGGAGE.

SELECT AVG( LUGGWEIGHT ) AS AVERAGE SUM( LUGGWEIGHT ) AS SUM

INTO CORRESPONDING FIELDS OF LUGGAGE

FROM SBOOK.

WRITE: / 'Average:', LUGGAGE-AVERAGE,

/ 'Sum :', LUGGAGE-SUM.

Please award points if found useful.

Cheers,

Chandra Sekhar.