Help with CASE statement?

[Baylah]

This Auto-Enter Calcluation does not seem to work.

Result = Case(height<.75;"Restrict"; height>1.25;"Restrict";width>3;"Restrict";" ")

Fields =

Height

Width

Result

This does work:

Result = Case(height<.75;"Restrict";width>3;"Restrict";" ")

But I need the full calculation to restrict if the first measurement is shorter than .75 and taller than 1.25.

Any help would be greatly appreciated.

thanks,

Steve

[Genx]

Hey Baylah.

Why not use, "height <.75 and height >1.25" as your first condition

[Baylah]

I tried that but not with the word "and" in between...let me see if it works that way.

Does not work that way

Steve

[Fitch]

In our universe, a number can't be both less than .75 and greater than 1.25 (you must have meant OR rather than AND). The calc works fine as written. Make sure your height field is a number field and the result field is text. Also try unchecking the "do not replace" checkbox in the auto-enter options.

[Baylah]

It still seems to ignore the second parameter.

If I type:

Case(height<.50 or height>1.25;"restrict";width>3.00; "restrict"; " ")

The result I get in the populated fied is if I enter size smaller than .50 it restricts as it should, but if I put in a height larger than 1.25 I get no return at all.

it seems like any statement other than the first is not evaluated.

Any help?

Thanks,

Steve

[Genx]

Oh right, sorry Fitch, i don't think i was paying attention to what i was saying.

Anyway Baylah, try the following:

If( height < 0.5 or height > 1.25 or width > 3; "restrict" ; " " )

My guess is with the quotes everywhere, you may have accidentally commented out some of the tests?

[Fitch]

I'm telling you, it works fine as written. See attached.

test.fp7.zip

[Baylah]

Thank you, thank you, thank you!

Steve