If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#Num! Error on Report
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! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200808/1 |
#2
|
|||
|
|||
#Num! Error on Report
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. -- Dave Hargis, Microsoft Access MVP "MichelleM via AccessMonster.com" wrote: 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! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200808/1 |
#3
|
|||
|
|||
#Num! Error on Report
I got it to work, thank you for your help!
Klatuu wrote: 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! -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|