Validated by calculation with If statement?
I am trying to figure out the syntax to validate a field.
As in, if Field1 = x and Field 2 < y, then value for Field 3 must be "0". Should I be using an If statement in the calculation window? I am using the following statement but its not working and I am thinking I'm going about this the wrong way.
In the Validation by Calculation window for Field 3 I am doing the following:
If ( Field = "x" and Field 2 < "110"; 0 )
Anyone know what I'm doing wrong?