Not Equal to function

[Anonymous]

Hi

I want to Exclude all 'APP' records from one of the field of the table.

I am using my syntax as  : If(Not wildmatch(Status ,'APP',''), Status)

Could you let me know its correct Syntax.

Regards

[tresesco]

Syntax looks okay. Where do you use this filter, in a chart calculation or in the script to exclude the data?

[sunny_talwar]

Are you doing a wild card search where you look for the word APP? May be you need this

If(not WildMatch(Status ,'*APP*'), Status)