Case function goes crazy?

[michele]

Really weird, the case function gives me error messages (even when I try to use the filemaker example).

Case calculations it accepted before also get an error message (when inserting "" as a result it says 'an operator is expected here'

ex: Case(field=1,"",3) when I insert a number instead of "" it says 'This number can't be evaluated.

What can possibly be wrong, I have the same problem with fmp5 and fmp6, I even reinstalled fmp5.

Any answers?

[IdealData]

Try using ";" (semi-colon) to delimit the calculation instead of "," (comma)

I think FMP is seeing your commas as part of teh number, hence why it also complains about the number.

[Lee Smith]

What language are you using. There are a differences between the US and European versions, one is as Mark pointed out the use of ";" instead of ",". I've noticed that in the French version, they use "Test" instead of "Case", (thanks UGO).

HTH

Lee

[ernst]

Hi Michele,

You can also try to add spaces before and after the numbers, i.e.

Case(field= 1 ,"", 3 )

This usually does the trick for me.

Regards,

Ernst.

[-Queue-]

Why not just use Case( not field = 1, 3 )? "" isn't necessary. And if field is a boolean, then you can omit the "= 1" portion too.

[michele]

Ernst your trick did it!

The reason why it changed was probably because I changed my keyboard settings.

So every answer I got (also yours Queue) was very usefull.

Thanks.

[ernst]

Hi Michele,

Glad it helped!

Ernst.