if then statement. . . .

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

Guest

Can Anyone help? I need this to return a zero for the jewelery value if the
currentctw is not zero. The jewelrylinetotal should be zero if the currentctw
is more than zero. . . thanks!

JewelryLineTotal:
CCur(IIf([CurrentCTW],0)=0,(([Quantity]*[AdjustedPrice])*(1-[Discount])*100)/100),Nz([CurrentCTW],0)))
 
how about

JewelryLineTotal:
CCur(IIf(Nz([CurrentCTW],0) > 0,
0,(([Quantity]*[AdjustedPrice])*(1-[Discount])*100)/100))

hth


SD Diamonds said:
Can Anyone help? I need this to return a zero for the jewelery value if the
currentctw is not zero. The jewelrylinetotal should be zero if the currentctw
is more than zero. . . thanks!

JewelryLineTotal:
Click to expand...
CCur(IIf([CurrentCTW],0)=0,(([Quantity]*[AdjustedPrice])*(1-[Discount])*100)
/100),Nz([CurrentCTW],0)))
 
Back
Top