IFF calculation on form

[Jaik]

=(Nz([Payment],0)+Nz([Balance],0))*0.01

So far I have calculation code like this. I am trying to add iif function to filter where Code column = SAVE


=IIf([Code]="SAVE",Nz([Payment],0)+Nz([Balance],0)*0.01,0)

So I have something like this, but I am getting weird numbers. However, Original calculation spits out right numbers.
Is there any way to fix this problem?

[ranman256]

the brackets may be a problem,
you must use the text box names on the form that have these values. (not field names, but they could be the same)

=IIf(Code="SAVE",Nz(Payment)+Nz(Balance)*0.01,0)

[ssanfu]

You have the parenthesis in the code box different than the calculation you typed in. Look close for the RED parenthesis

=(Nz([Payment],0)+Nz([Balance],0))*0.01

Here you are adding [payment] and [balance], then multiplying the total by 0.01

=IIf([ Code ]="SAVE",Nz([Payment],0)+Nz([Balance],0)*0.01,0)

Here you are multiplying [balance] by 0.01, THEN adding [payment] ....NO grouping parenthesis



Try:

=IIf([ Code ]="SAVE",(Nz([Payment],0)+Nz([Balance],0))*0.01,0)

This has the grouping parenthesis (in RED)




Note: I had to add spaces around the word code because "code" is a tag in the HTML of the page. So ignore the extra spaces around code.

[Jaik]

Thanks guys for the help!