8 Replies Latest reply: Jan 23, 2013 8:17 AM by ali ceyli RSS

    Not include in set expression

    ali ceyli

      Hello everyone,



      This is my example

      COUNT(if(wildmatch(UPPER(field_name),'*value1*','*value2*') AND NOT wildmatch(UPPER(field_name),'*value3*'),field_name3))

      with and not wild match I try exclude value3 (I couldnt succeed)

      and my second expression is

      COUNT({$<field_name2={">=$(=0) <$(=31)"},field_name={'*value1*','*value2*'}>}field_name3


      As result I want to combine two expression in one expression