Divide Sum by Count in 2007 Pivot

[Legacy 171839]

Hi all,

I have a pivot, top line of which looks like:

Name Count of Day Total Time
Joe Blogg 2 180

Using calculated fileds, i'm tring to add a 4th field which will divide Total Time (which is a sum), by Count of Day (which is count).

When I simple do Total Time/Count of day, I get #DIV/0!

When I try =SUM('Total Time') /COUNTA(Day), it returns 180. Doesn't divide.

As I have a large dataset as it is, I would really like to avoid putting an additional 1/0 column in, to add the 1's instead of counting, so if anyone knows how to do this in the pivot in 2007, much gratitude and positive thoughts will come your way.

Thanks in advance
Frierpie

 

[Legacy 171839]

Hi all,

I have a pivot, top line of which looks like:

Name.................Count of Day.......... Total Time
Joe Bloggs....................2..................... 180

Using calculated fileds, i'm tring to add a 4th field which will divide Total Time (which is a sum), by Count of Day (which is count).

When I simple do Total Time/Count of day, I get #DIV/0!

When I try =SUM('Total Time') /COUNTA(Day), it returns 180. Doesn't divide.

As I have a large dataset as it is, I would really like to avoid putting an additional 1/0 column in, to add the 1's instead of counting, so if anyone knows how to do this in the pivot in 2007, much gratitude and positive thoughts will come your way.

Thanks in advance
Frierpie

Apologies - just realised the formatting of original message didnt make it very clear - hope this helps