Caculating the Balance

hello friends

i have these field as database fields

EntryNo
EntryDate
Remarks
Dr
Cr

and i want to add one column as a balance by using formula

just like this

EntryNo EntryDte Remarks Dr Cr balance

1 02/02/2006 fg 20 0 20
2 03/03/2006 ff 50 0 70
3 05/03/2006 dd 80 0 150
4 06/03/2006 kk 150 0 300
5 05/04/2006 tt 30 270


so how can i get the balance like this by using formula
please help

thanksuse a running total field based on formula
if dr=0 then
-cr
else
dr|||-cr should be -1*cr|||Hi if you still need a soluton you can try this way
Create formula field (BP) Bp = dr-cr
place it next to coulmn cr>right click >format editor and choose to suppres it.
Create another formula filed(balance).. balance = Bp+previous(Bp)
place it next to column Bp
hope this works as you expect
do reply if it works out
regards