Subtotal Formula

[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)))

 

[Michel Walsh]

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

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)))