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

    Wildmatch not validating properly with if condition

    Supriya R



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



      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