3 Replies Latest reply on Apr 14, 2011 2:55 PM by philmodjunk

    calc field -- what am I doing wrong?

    firth5

      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?