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))
"AdamZ" wrote:
[Quoted Text] > 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
|