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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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))
 
Back
Top