Hi everyone

I don't seem to be able to acheive the calculation I need in a pivot table. I need the 'Liability' total divided by the 'Count of Branch' but I keep getting the 'Divided by Zero' error. I have tried changing numeric values to count also but that just calculates the total numeric value that sits behind. What am I doing wrong? Any tips will be greatly appreciated.

Values
Row Labels Count of Branch TOTAL LIMITS Sum of Field3
FIDELITY COMM 7,597 3,655,800,000 #DIV/0!
FIDELITY FIN 375 25,014,500 #DIV/0!
MLC 9,169 27,463,660,000 #DIV/0!
MLF 375 68,785,500 #DIV/0!
PI 5 7,500,000 #DIV/0!
Grand Total 17,521 31,220,760,000 #DIV/0!


Cheers

Derek