I have several pivot table reports - in some the datwa is shown as $
format, in others the data is shown in Count format.

I want to create a new table which simply divides the $ data from one
table by the count data from another. However, when I use the pivot
table formula function to do this I can select the fields OK but I get
an error result. The formula seems to have trouble dividing a $ format
by a Count format. Does anyone know how to get around this?

Thanks, Simon