I tried it and it returns all zeros. There is actually data that it needs to
return too.

"KARL DEWEY" wrote:

> Try this --
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10670-iif-expression.html
> 35 DN Bonus: IIf([Dnpmt Perc Of Total]>=0.35 And [Dnpmt Perc Of
> Total]<1,IIF([35% Down Bonus]![Total35% DN Bonus] Is Null, 0,[35% Down
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10670
> Bonus]![Total35% DN Bonus]),0)
>
>
> "Xjcinhoustonx" wrote:
>
> > I have an expression for choosing whether to pay a commission stated as:
> >
> > 35 DN Bonus: IIf([Dnpmt Perc Of Total]>=0.35 And [Dnpmt Perc Of
> > Total]<1,[35% Down Bonus]![Total35% DN Bonus],0),
> >
> > This works fine unless the total in the [Total 35% Dn Bonus] field is 0,
> > then it just returns a blank. How can I fix this problem
> >
> >