I have 2 columns Received and Issued, what I want is to compute the 2 columns and show the result on Balance column.

for example:


i have a beginning balance of 100

I input 10 on received and no input on issued column on row(a)

now, if the issued column is equal to 0 then received
column will add to the beginning balance. and now the balance
is 110 on the row(a) where I input the "10".

Now, I input 30 on issued column and no input on recieved column on row(b)

then if the received column is 0 then issued column will subtract
to the balance of row(a) and the difference on Balance Column row(b) will be 80.


Anyone help me here. ..please. .

I need it on my report. .

Thanks in advance

You can use variables to accomplish this as well.

Declare your beginning balance in the report header as a global variable.

For each record, add the amount in the "received" box to the variable, and subtract the amount in the "issued" box from the variable.

In the report footer, print out your variable.

With a running total, write a new formula that calculates the difference between received and issued, then sum on that formula.

Edited by Keikoku - 28 Apr 2011 at 6:36am