syntax error in expression

[#1]

Hi,

I have one field value 'Supervisor's Opinion. when I am trying to use this MixMatch I am getting syntax error. could anyone tell mw how can I write this without error.

=

if(MixMatch([Error Types],'Supervisor's Opinion'

[vikasmahajan]

Please type your expression to help you  better , you are giving incomplete information , While posing in community you should create dummy qvw along with your post so that other person can help you soon..................

vikas

[tresesco]

If you are using the braces properly, then this could be because of the single quote in the string.

[er_mohit]

try this way

=Count({<[Error Types]={"Supervisor's Opinion"}>}[Error Types])

or try this way

if(MixMatch([Error Types],'Supervisor'&chr(39) &'s' &' ' & 'Opinion'),your expression)

[#5]

hi

try this

=

MixMatch([Error Types],'Supervisor & chr(39) & 's Opinion')

***********************************

The mixmatch function performs a case insensitive comparison.

Example:

mixmatch( M, 'Jan','Feb','Mar')

returns 1 if M = jan

*************************************

[#6]

try chr(39)  in

=

MixMatch([Error Types],'Supervisor & chr(39) & 's Opinion')

[nizamsha]

Load * inline [

Country

AUSTRALIA

INDIA

US

];

=MixMatch(COUNTRY,'AUSTRALIA','INDIA',US)

if the string AUSTRALIA,INDIA,US matches the country then it will return one else it will return o

[#8]

Not sure, if it is the actual mistake, but in the case the formula is correct don't forget to close the brackets, so

=if(MixMatch([Error Types],'Supervisor's Opinion'))