Does anybody see any error in the below if statement

[#1]

if(match(Category,'4','9','16','21','22')=0,'Trust_Non-Reccuring','Trust Reccuring') as Feetype,

When I run this script I am getting only one value i.e Trust_Non-Reccuring in the field Feetype.Why am I missing Trust Reccuring value from the field ?

Thanks in advance.

[swuehl]

Such a question is hard to answer without knowing the values from field Category.

[martinpohl]

try without = 0

if (match(value, matches), then , else)

Regards

[jerem1234]

Seems like nothing is matching your values 4,9,16,21,22. I would check your data. Maybe you are looking for a wildmatch?

if(wildmatch(Category,'*4*','*9*','*16','*21*','*22*')=0,'Trust_Non-Reccuring','Trust Reccuring')

But thats just a complete guess.

Hope this helps!

[chiru_thota]

Hi,

Match function returns position number if category values matches with 4','9','16','21','22...not always zero (0).

try this:

if(match(Category,'4','9','16','21','22') > 0,'Trust_Non-Reccuring','Trust Reccuring')

The match function performs a case sensitive comparison.

Example:

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

returns 2 if M = Feb

returns 0 if M = Apr or jan