"#Num!" Error display as "-"?

G

Guest

You all are saving my butt today. My gratitutde goes out to everyone...

Essentially, the following code throws #Num! because the Control Source is
trying to divide "0/0."

How do I get it to display a "-" instead?

=(Count(IIf([Product Type]="Allied" And [Transition Complete
YN]=True,[Wholesaler ID],Null)))/(Count(IIf([Product
Type]="Allied",[Wholesaler ID],Null)))

-Adam
 
G

Guest

I've tried this, but it doesn't work...

=IIf([Count(IIf([Product Type]="Allied" And [Transition Complete
YN]=True,[Wholesaler ID],Null] = 0, -, Count(IIf([Product Type]="Allied" And
[Transition Complete YN]=True,[Wholesaler ID],Null)))/(Count(IIf([Product
Type]="Allied",[Wholesaler ID],Null))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIF syntax problem... 1
"0" in a sum calculation not showing up? 1
Inner Join Question 3
Left Join Confusion 4
Overflow error 3
REPOST: Datatype mismatch issue 6
Java script memory leak 2
changing Error# generated by count() to zero 6

Top