If then else statement

[ptrifile]

I use the following formula to show Average Talk Time for a group of employees.

if ({iAgentPerformanceStat.CallsAnswered}) = 0 then 0 else round(sum({iAgentPerformanceStat.TalkTime}, {iAgentPerformanceStat.AgentSurName})/sum({iAgentPerformanceStat.CallsAnswered},{iAgentPerformanceStat.AgentSurName}));

This formula works great if the first person listed in the report has answered calls during the specified time period, however, if the first person listed has zero calls answered then everyone on the report shows as zero. Does this make sense to anyone? Can someone offer a possible solution?

Thanks in advance

Paul

 

[dgillz]

What section of the report is this located in?

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[ptrifile]

Thanks for the follow up dgillz. I just figured out the issue. I needed to do a left outer join instead of an inner join. Once I made that change I got the desired resuts.

Thanks again!

Paul