IIf expression

#1 (**permalink**) 28-Jul-2006, 08:15 AM

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),
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10670-iif-expression.html

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

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10670

*

#2 (**permalink**) 28-Jul-2006, 08:15 AM

Try this --
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
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,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10670
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10670
> then it just returns a blank. How can I fix this problem
>
>

#3 (**permalink**) 28-Jul-2006, 08:15 AM

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

"KARL DEWEY" wrote:

> Try this --
> 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
> Bonus]![Total35% DN Bonus]),0)
>
>
> "Xjcinhoustonx" wrote:
>
> > I have an expression for choosing whether to pay a commission stated as:
> >
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10670
> > 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,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10670
> > then it just returns a blank. How can I fix this problem
> >
> >