Re: [pilot-db-list] ffr-script question (pilot-db: message 11 of 20)

[Skeeve <Ske...@gm...>]

Mark Wiehland - Mar...@gm... wrote:

>Dear mailinglist,
>
>My database design for an overtime calculation:
>
>Field 0: date 	-> Date
>Field 1: hour 	-> float
>Field 2: reason	-> string
>Field 3: total	-> calculated - should add all hours from all records
>
>So I would like to add together field 1 and field 3 from the last
>record, if there is one, or alternatively add together field 1 from all
>records.
>I tried (+ %1 (ffr -1 3)), which gives me an "bad argument" error
>  
>
Try
(sort 0 1)(+ (ffr 3 -1 0) %1)