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!

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

Sorry about that.

"Joyce" wrote:

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!

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!

"Joyce" wrote:

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

Sorry about that.

"Joyce" wrote:

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!