Wildmatch not validating properly with if condition

[berryandcherry6]

Hi,

i have a column called resident Type where i need to get sum of row which contains  "-other" String but not  "home -other " string .

Example:

Hotel -other

pg -other

home -other

home -other

Hotelwe -other

pgsds -other

i need to get sum as  4.

Now i am using below code but i get value 0. What i am doing wrong.

sum(if((wildmatch(resident Type,'*-other') and not wildmatch(resident Type,'home -other')),1,0)) = 0

[sunny_talwar · Accepted solution]

Try this:

=Count({<[resident Type] = {'*-other'}-{'home -other'}>}[resident Type])