Re: [pilot-db-list] a calculated field

[Dan D <mt...@ho...>]

I am attaching a file that should be what you are looking for.

I set it up as this
Field 0 Date               Date
Field 1 Concept            String
Field 2 Exp/Inc            Integer
Field 3 Balance            Calc

Calc "(sort 0 1)(+ %2 (ffr 3 -1 0))

Thanks go to Scott for helping me out on this one.  I had the same question 
earlier.

Ciao Dan
Enjoy

>From: Pablo Rodriguez <ou...@gm...>
>To: pil...@li...
>Subject: [pilot-db-list] a calculated field
>Date: Thu, 12 Dec 2002 22:59:11 +0100
>
>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
>
>
>
>-------------------------------------------------------
>This sf.net email is sponsored by:
>With Great Power, Comes Great Responsibility Learn to use your power at 
>OSDN's High Performance Computing Channel
>http://hpc.devchannel.org/
>_______________________________________________
>Pilot-db-list mailing list
>Pil...@li...
>https://lists.sourceforge.net/lists/listinfo/pilot-db-list


_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* 
http://join.msn.com/?page=features/junkmail