Display Totals of Calculated Field

[Joyce]

Hello,

I've inserted some calculated fields that are working fine. (I'm using Excel
2007)

I am grouping by year, and the 'regular' fields show the subtotals by year,
but my calculated fields do not show subtotals at all.

Any suggestions would be appreciated!

 

[Joyce]

I removed some subtotals and the calculated field totals magically appeared.
Not sure why, but it's working.

Sorry about that.

 

[Joyce]

I spoke too soon. Yes, I'm getting totals, but some of them are incorrect.
If I create a calculated field that simply subtracts one field from another,
the subtotal is correct. However, if I divide one field by another, the
subtotal is incorrect.

Am I better to add these columns to my data as opposed to creating
calculated fields?

Thanks!