Help with Expression builder

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

Guest

This is my first time here and hope someone can help me. I'm trying to
multiply a field by a number, now that in it's self was easy. But depending
on the numbers value it needs to be multiplied by a different number. This
is what I have so far:
Expr1: [invd_units_ext]*0.04 but if [invd_units_ext] is 0 to 999 it needs to
be multiplied by 0.04 but if it is 1000 to 9999 it needs to be multiplied by
0.03.

Any help with this would be greatly appreciated.
 
See if this works: Expr1:
IIf([invd_units_ext]<1000,[invd_units_ext]*0.04,[invd_units_ext]*0.03)

Check it, because I'm no expert
 
Back
Top