How to total values that involves different record

[deo]

Is it possible to sum up a particular value for all records? I'm using the an Expense Report from the canned template but would like to customize the list view to show a grand total of all expenses for all records.

TIA

Deo

[Vaughan]

Summary fields.

[deo]

I get Summary fields for within a record. But what about if you have 35 records where each has a field called Total Value and you want to summarize all 35 and show the result in a list view. Is this possible?

TIA,

Deo

FM Newbie

[deo]

Hey..., Thanks Vaughan for pointing out the obvious. Thanks for your time.

[Vaughan]

"Thanks Vaughan for pointing out the obvious."

OK. Now for the not-so-obvious...

Summary fields are good and easy but can be very slow especially with large data sets over the network. An alternative in many cases is to use relationships and calculated fields.