=
I created this expression from other 2 expressions
Expr3: IIf([Expr1][Expr2],"MISS","HIT")
Expr1 is a variance from Field1 and Field2
Expr2 is Field2 x 2%
Expr3 should be a "HIT" if Expr1 is Expr2
or = should be a "MISS"
but when I have a large negative qty is making it a "HIT" when it should
really be a "MISS"
|