Sum of all the values in a field

[Former Member]

I have a report which needs to sum all the values of KONV-KBETR where KONV-kinak NE 'A'.

How do i write the code.

Can anyone help me in wrting the code..

This value i have to finally display in my internal table as one value.

[Former Member]

HI,

Check the below code...

IF konv-kinak NE 'A'.

v_kbetr = konv-kbetr + v_kbetr.

ENDIF.

Cheers,

Bujji

[Former Member]

Bujji..

But the value v_kbetr is not constant..

And morever i dont know what the values are there in the field konv-kbetr.

could you help me further.

[Former Member]

Hi Mona,

slight change..

data:w_kbetr type konv-kbetr.

loop at konv.

if konv-... ne 'A'.

W_kbetr = w_kbetr + konv-kbetr.

endif.

endloop.

i hope this wil help u...

Regards,

Kaveri

[Former Member]

Hey Kaveri..

Thanks.

I think that should work..

[Former Member]

Hi Mona,

I think you forgot to allocate marks )))))))))

Regards,

Kaveri

[Former Member]

data: sumf type i.

select sum( kbetr ) from konv into sumf where kinak <> 'A' group by konv.

write: sumf.

Message was edited by:

Ramu

[Former Member]

within a IF statement you can use a collect statement