1 Reply Latest reply: Jan 3, 2017 12:15 PM by Sunny Talwar RSS

    Wildmatch not validating properly with if condition

    Supriya R

      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