topic Re: calculation in Application Development and Automation Discussions

calculation

Former Member — Mon, 21 Apr 2008 07:06:50 GMT

Hi All

I have a requirement,i have opening balance,debit and credit amount.suppose i have opening balance of 10

my formula is balance = opening bel + debit + credit

debit ,,,credit ,,,balance

1 ,,,, 2 ,,, (1021)= 13

but for second doc onwards it should be balance (not ope bal)+debit + credit

debit ,,,credit ,,,balance

3 ,,,, 4 ,,, (1334)= 20

5 ,,,, 6 ,,, (2056)= 31

7,,,, 8 ,,,, (3178)=46

Pls Help me.

Regards

Lalith

Re: calculation

Former Member — Mon, 21 Apr 2008 07:11:35 GMT

loop at itab.

if sy-tabix = 1.

balance = openbal + credit + debit.

else.

balance = balance + credit + debit.

endif.

endloop.

Re: calculation

Former Member — Mon, 21 Apr 2008 07:14:19 GMT

Hi,

Try setting a flag. For ex,

data: gf_flag type i .

if gf_flag <> 1.

balance = opening bel + debit + credit.

gf_flag = 1.

else.

balance = balance + debit + credit.

endif.

Regards,

Ramya

Re: calculation

Former Member — Mon, 21 Apr 2008 07:17:53 GMT

Hi,

data: v_flag type c value 'X'.

loop at itab.

if v_flag = 'X'.

balance = openbal + credit + debit.

clear v_flag.

else.

balance = balance + credit + debit.

endif.

endloop.

Re: calculation

Former Member — Mon, 21 Apr 2008 07:27:35 GMT

Hi,

Balance = 0.

loop .

balance = balance + credit + debit.

endloop.

I think it is useful for you.

Re: calculation

Former Member — Mon, 21 Apr 2008 07:49:09 GMT

i have given this logic , but balance = balance + credit + debit.

it is not taking balance of sy-tabix = 1 only in sytabix = 1 it should take openining balance elsewhere it should take balance of previous doc no.

loop at itab.

if sy-tabix = 1.

balance = openbal + credit + debit.

else.

balance = balance + credit + debit.

endif.

endloop.

Re: calculation

Former Member — Mon, 21 Apr 2008 07:56:09 GMT

if balance is INITIAL

balance = open bal + credit...

else

bal = bal +

Check whether this logic will satisfy ur purpose