Sum total on our report is not working

[Forums10]

The code that we have tried to total the column Profit or Loss $ without success
===
sum([ProfitLoss])
=(Sum([ProfitLoss]))
sum=([ProfitLoss])
sum(=Nz([BookValue_Market])-Nz([BookValue_Cost]))
sum(Nz([BookValue_Market])-Nz([BookValue_Cost]))
=sum(Nz([BookValue_Market])-Nz([BookValue_Cost]))
=Sum(([BookValue_Market])-([BookValue_Cost]))


Sum(([BookValue_Market])-([BookValue_Cost]))
Sum([BookValue_Market])-([BookValue_Cost])
===
Can I please have a suggestion on how to have a total for our reports?
.
Thank you
Barbara

[June7]

Aggregate functions cannot reference controls, only fields in the report RecordSource. Do the calcs for [BookValue_Market] and [BookValue_Cost] in a query that is the RecordSource. Bind controls to those constructed fields and reference those fields in the aggregate calc.

BTW, advise not to use spaces and special characters/punctuation (underscore is exception) in naming convention.

[pbaldy]

You can't sum a calculated control, only fields. You can recreate the calculations in the sum, or copy the ProfitLoss textbox, set the running sum property of the copy to Over All, hide it, and refer to it in the report footer.