AnsweredAssumed Answered

calc field -- what am I doing wrong?

Question asked by firth5 on Apr 14, 2011
Latest reply on Apr 14, 2011 by philmodjunk

Title

calc field -- what am I doing wrong?

Post

I have the following calc field  (We'll call it RESULT_FIELD)

Sometimes my result is working, sometimes not.

-------------

Case (

FIELD1 = 8 and FIELD2 > 8; "COMPLETE";

FIELD1 = 8 and FIELD2 = 8; "PHASE 2";

FIELD1 = 8 and FIELD2 = 7; "PHASE 1;

FIELD1 = 8 and FIELD2 = 1 or 2 or 3 or 4 or 5 or 6; FIELD2;   /* returns data entered in field2 if true */

FIELD1 = 10 and FIELD2 > 10; "COMPLETE";

FIELD1 = 10 and FIELD2 = 10; "PHASE 2";

FIELD1 = 10 and FIELD2 = 9; "PHASE 1;

FIELD1 = 10 and FIELD2 = 1 or 2 or 3 or 4 or 5 or 6 or 7 or 8; FIELD2;   /* returns data entered in field2 if true */

-----------

in case it matters:

FIELD1 and FIELD2 are number fields; RESULT_FIELD is a text field.

FIELD1 has a validated pull-down list of either "8" or "10"

In general, everything is working when data in FIELD1 is "8"

But NOT working when data in FIELD1 is "10".

What am I doing wrong?

Outcomes