Calculations with multiple records. Urgent help needed please

[HPage]

Say I have multiple records that each have a different car's details, and I want to get an avergae of the all the cars' speeds. How do I do that? Or If I want the sum of all values in all the records of a specific field. I need this urgently for a school project, and help with this matter would be greatly appreciated! :

Thanks!

[Ocean West]

setup a summary field to do Total of or Average of.

Place it in the grand summary or footer of a list view layout.

Edited September 12, 2006 by Guest

[Fei]

Create a summary field and choose AVERAGE of SPEED field.

Is this what you want?

[HPage]

That was quick! Thanks, but I know I can use summary fields, the thing is, In my project I get marks for functions, calculations, formulas used,(the other kids are using MS Access, im the only one using filemaker, its actually an Accsess project) so Id rather use calculations (if its possible) to do it. The other thing is, say I have an average, how can I for instance ROUND it, when Im using a summary and not a calculation...

[Fei]

Create a QTY (number) field with auto enter data =1

Create a calculation field

Sum (Speed) / Sum(qty)

[HPage]

When I use the sum function, it only gives the sum of the one field in the current record, not the sum of the field in all records...

[Fei]

You have to create a portal to get the result.

Each of the cars record is the portal item.

[HPage]

Ok I will do that, thankyou very much for the help and quick replys!