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
|
