Re: [pilot-db-list] Little Help with a calculated field

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

Thanks for getting back so quickly.  I tried the way you listed but it 
didn't work.  I will try by adding another column.

Thanks






>From: Scott Wallace <swa...@my...>
>To: Dan D <mt...@ho...>
>CC: pil...@li...
>Subject: Re: [pilot-db-list] Little Help with a calculated field
>Date: Fri, 14 Feb 2003 13:32:36 -0500 (EST)
>
>On Fri, 14 Feb 2003, Dan D wrote:
> >
> > I currently have a calculated field in my Overtime Database that keeps 
>track
> > of my overtime at my client.  Basically I have the 2nd field added to 
>the
> > privious total to have a running total.  I only get paid once I go over 
>80
> > hrs of overtime so I wanted to start my total at -80.  How would I do 
>that?
> > The way mine currently works is by "(sort 0 1)(+ %1(ffr 2-1 0))".
>
>Hmm.  Does "(sort 0 1)(+ %1 (ffr 2 -1 -80))" work?
>
>The third value in the 'ffr' is the default value.  Its what is used when
>an appropriate record can't be found.  In this case, that should only be
>for the very first record in the sorted order.  So it seems like the only
>problem may be that this script will never allow you to reset to -80 once
>you get paid....If that's important, an extra field might be necessary...
>
>	-Scott
>
>
>
>-------------------------------------------------------
>This SF.NET email is sponsored by: FREE  SSL Guide from Thawte
>are you planning your Web Server Security? Click here to get a FREE
>Thawte SSL guide and find the answers to all your  SSL security issues.
>http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en
>_______________________________________________
>Pilot-db-list mailing list
>Pil...@li...
>https://lists.sourceforge.net/lists/listinfo/pilot-db-list


_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.  
http://join.msn.com/?page=features/virus