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?

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.

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

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.

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.

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.

Hi Michele,

Glad it helped!

Ernst.