Subtotal Formula

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

Guest

I seem to have the wrong # of arguments? I was told that to have value b
calculated only when Value A is 0 I needed to use this format:
=IIf (Nz(A,0)=0, B, Nz(A,0)
I have modified it so that my fields are in it - but it doesn't work. can
anyone help? The jewelery line total should read "0" if the Currentctw is >1.
Thanks!
JewelryLineTotal:
CCur(IIf([CurrentCTW],0)=0,(([Quantity]*[AdjustedPrice])*(1-[Discount])*100)/100),Nz([CurrentCTW],0)))
 
Hi,


You are missing a closing parenthesis in

=IIf (Nz(A,0)=0, B, Nz(A,0)




probably at the very end.


Hoping it may help,
Vanderghast, Access MVP


SD Diamonds said:
I seem to have the wrong # of arguments? I was told that to have value b
calculated only when Value A is 0 I needed to use this format:
=IIf (Nz(A,0)=0, B, Nz(A,0)
I have modified it so that my fields are in it - but it doesn't work. can
anyone help? The jewelery line total should read "0" if the Currentctw is
1.
Click to expand...
Thanks!
JewelryLineTotal:
CCur(IIf([CurrentCTW],0)=0,(([Quantity]*[AdjustedPrice])*(1-[Discount])*100)/100),Nz([CurrentCTW],0)))
Click to expand...
 
Back
Top