[pilot-db-list] a calculated field

[Pablo R. <ou...@gm...>]

Hi there,


I wanted to make an simple expense tracker database. Field 0 contains the 
date, field 1 the concept, field 2 the amount, field 3 income/expense, and 
field 4 contains the total.

The field 4 contains a script that adds or subtract (according to field 3) 
the field 2 to the value of field 4 of the previous record. How should the 
script be written? (Sorry, after reading the documentation three times, I'm 
afraid that it's beyond my mathematical capabilities.)

By the way, how can I have that numbers with two decimals don't get rounded?

Thanks for your help,


Pablo