Good day,
I have the following expression in a query:
ATT: IIf(Sum([Main].[acd_time]+[Main].[hold_time])/Sum([Main].[acd_calls])=0,0,Sum([Main].[acd_time]+[Main].[hold_time])/Sum([Main].[acd_calls]))
But the IIF is still returning the #Error, I was wondering if anyone would know why this would still be happening.
Good to be back,
Chris
________
buy silver surfer
I have the following expression in a query:
ATT: IIf(Sum([Main].[acd_time]+[Main].[hold_time])/Sum([Main].[acd_calls])=0,0,Sum([Main].[acd_time]+[Main].[hold_time])/Sum([Main].[acd_calls]))
But the IIF is still returning the #Error, I was wondering if anyone would know why this would still be happening.
Good to be back,
Chris
________
buy silver surfer
Last edited: