#Error resullts from a query

[opkpapp11]

Hello,

I made a custom column in my query that adds two colmuns and then divides by another. The problem is sometimes that column dividing is zero thus i get an "#Error" as the column data.

Does anyone know how to fix this? I would like it to just show up as 0 rather then #Error


AHT: ([SumOfacdtime]+[SumOfacwtime])/[SumOfacdcalls]

 

[jedraw]

I think this should work.

AHT: iif ([SumOfacdcalls] <> 0,([SumOfacdtime]+[SumOfacwtime])/[SumOfacdcalls]),0)

 

[jedraw]

Oops,

I think
AHT: iif ([SumOfacdcalls] <> 0,([SumOfacdtime]+[SumOfacwtime])/[SumOfacdcalls]),0)
is missing a bracket.

AHT: iif ([SumOfacdcalls] <> 0,([SumOfacdtime]+[SumOfacwtime])/([SumOfacdcalls]),0)

 

[opkpapp11]

well done sir, thank you.