IIf expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
I tried it and it returns all zeros. There is actually data that it needs to
return too.

KARL DEWEY said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top