IIF question (1 Viewer)

durdle

Registered User.
Local time
Today, 16:31
Joined
May 7, 2002
Messages
130
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
 
Last edited:

Mile-O

Back once again...
Local time
Today, 16:31
Joined
Dec 10, 2002
Messages
11,316
Dividing by zero, perhaps?
 

neileg

AWF VIP
Local time
Today, 16:31
Joined
Dec 4, 2002
Messages
5,975
Try some extra brackets

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]))
 

Users who are viewing this thread

Top Bottom