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!