8 Replies Latest reply: Jan 23, 2013 8:17 AM by ahnet ceylan RSS

    Not include in set expression

    ahnet ceylan

      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