Trouble with Case function

[swf]

Is this a valid argument for a calculated field checkbox

Case(testfield="a" or "b";1;)

Should place a 1 in the checkbox if the testfield is either a or b

To expand:

Is this valid

Case(testfield=("a"or"b") and testfield2 >"5";1;)

should place a 1 in the checkbox if the testfield is either a or b and simultaneously the testfield2 >5.

Seems like it should work but I am not having success.

[Ender]

Try:

(testfield="a" or testfield="b") and testfield2>5

The field needs to be part of each test. The Case is redundant if the calc field is a number.

[swf]

thanks, works great