Hi, I am creating a report with employee statistics. I created fields that count each employee by a specific criteria and decided to create a report that shows statistics. The report is looking great execpt that I am trying to calculate percentage and for some reason I get #Num! when its a 0/0. for example:

count female = 0
count bfemale = 0

I have: =((sum([count bfemale]))/(sum([count female]))) and the field is formatted as a percentage. how can I get the field to just show 0%. I noticed that even if the total count has a number and the second criteria is 0, then it shows me 0% which is fine.

Hi,
try:

IFF([count female]= 0,0,Sum([count bfemale])/(sum([count female]))

Should work I think.
HTH
Good luck

P.S.
BTW you should avoid using spaces in your field names.