#Num! Error on Report

[MichelleM via AccessMonster.com]

I have created a report to view stats on a call handler agent. I have a
calculated control source for their quality score, which is a percentage:
=(Sum(AgentReportCard!RecordingScore))/(Sum(AgentReportCard!RecordingCount))*
(0.01)

If the report is ran for a time period where they do not have a score, #Num!
is returned on my report. I have tried this for a fix:

=IIf([HasData],(Sum(AgentReportCard!RecordingScore))/(Sum(AgentReportCard!
RecordingCount))*(0.01),"N/A")

And it didn't work. If the agent does not have a score for the time period,
I would like it to return N/A. Any suggestions?

Thank you!

 

[Klatuu]

The problem is a divide by zero problem.
=IIf([HasData],(Sum(AgentReportCard!RecordingScore))/(Sum(AgentReportCard!
RecordingCount))*(0.01),"N/A")

You need to be sure that the results of this Sum
Sum(AgentReportCard!RecordingCount) is not zero. You can do that with an
IIf statment, but what you replace the 0 with should be defined by your
business rules.

 

[MichelleM via AccessMonster.com]

I got it to work, thank you for your help!

The problem is a divide by zero problem.
=IIf([HasData],(Sum(AgentReportCard!RecordingScore))/(Sum(AgentReportCard!
RecordingCount))*(0.01),"N/A")

You need to be sure that the results of this Sum
Sum(AgentReportCard!RecordingCount) is not zero. You can do that with an
IIf statment, but what you replace the 0 with should be defined by your
business rules.

I have created a report to view stats on a call handler agent. I have a
calculated control source for their quality score, which is a percentage:

[quoted text clipped - 11 lines]

Thank you!