Trailing Grand Summary Isn't Working

[Mary Office Manager]

I have a layout part, Trailing Grand Summary. And I want to have a total cost on my report. In the body of the layout I have the cost field from the Asset table. In the Trailing Grand Summary, I have the same cost field from the Asset table. However, the Trailing Grand Summary Cost field is only displaying the cost of the last line item instead of adding all costs on all lines. What am I doing wrong? I don't think I need to build a relationship since the field is from the same table, right? Help please. :)

[mr_vodka]

Is your report based on the same table?

[Mary Office Manager]

Yes, my layout is based on the Asset table.

[mr_vodka]

Sorry to ask but it is definately a summary field in the same table right?

[Mary Office Manager]

I don't mind you asking at all...what do you mean by, "Is it a summary field?" Is that an option I need to set when the field is created in Defining Database under options?

[mr_vodka]

Yes under define databases when you are creating the field, there is a type summary.