In FileMaker Pro 6... (still, yes!)

I need to Define a global variable with the sum of the values of a field after 
sorting the files according to a specific criteria.
I used the function SUM(field)... but curiously, the result hold only the value 
of the first file sorted.

Any idea of what is going wrong?

Thanks

Paul Richard <ppat2000@yahoo.com> wrote:

> In FileMaker Pro 6... (still, yes!)
> 
> I need to Define a global variable with the sum of the values of a field
> after sorting the files according to a specific criteria. I used the
> function SUM(field)... but curiously, the result hold only the value of
> the first file sorted.

The Sum function aggregates values from a repeating field or a
relationship. It doesn't do subsummaries. For that you define a summary
field (sum of ... ) and use the GetSummary function to store the
subsummary value in a field. 
-- 
Hans Rijnbout
Utrecht, Netherlands