Display Totals of Calculated Field
 

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!

Display Totals of Calculated Field
 

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!

Display Totals of Calculated Field
 

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!