4 Replies Latest reply: Oct 21, 2014 2:07 AM by jagan mohan rao appala RSS

    Set Analysis Set Modifier - Everything Except

      I've been searching for the correct syntax, but have come to a dead end. I think it should be something simple.

       

      Basically I am trying to use set analysis to use everything except ' value '

       

      Example:

      Statuses:

           Approved

           Open

           Closed

       

       

      This gives the results I want - {$< Status = {'Approved','Open'}>}

       

      I am looking for something like - {$< Status = { * - 'Closed'}>}

       

      So it is basically everything not in status closed. In this example it makes sense to just type it out, but when the values are text and in large distinct quantities it makes set up monotonous. I assume there is a syntax for it and it's simple, but I have not come across it in my research.

       

       

       

      If I am not explaining it well enough, please let me know.