3 Replies Latest reply: Oct 21, 2015 11:30 AM by Sunny Talwar RSS

    Set Analysis - Multiple Qualifiers on Same field - Less than

    Dave Melillo

      Couple of questions here -

      1. What is the best way to apply multiple qualifiers to the same field in set analysis?

      2. What is the best way to apply a less than qualifier to a certain field?

       

      Example is below: Trying to count distinct items where the Code is NOT LIKE 152621* and is less than 15400000

       

      count({<

       

       

      [Code]-={'152621*'},

       

       

      [Code] ={"< $(=15400000)"}

       

       

      DISTINCT(

       

       

      [Item Number]))