AnsweredAssumed Answered

Validated by calculation with If statement?

Question asked by vtdonn on Jun 1, 2015
Latest reply on Jun 2, 2015 by philmodjunk

Title

Validated by calculation with If statement?

Post

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?

Outcomes