3 Replies Latest reply: Jun 14, 2011 8:30 AM by Sunil Kenth RSS

    Exclude data based on selection

    Sunil Kenth

      Hi All,

       

      I have a data set which has some 'dirty' data in.  I would like to exclude this dirty data when a selection is made.

       

      This is what I have:

       

      A selection box called 'Status', with the following values:

      Active

      Cancelled

      Completed

      On Hold

       

      A table box containing the following columns:

       

      Name

      Start Date

      Finish Date

      Status

      % Complete

       

      What i would like to do is exclude entries in the table box that have a value of 100% in the '%Complete' column when the 'Active' status is selected.

       

      I figure i need some sort of set analysis to do this but not sure what the syntax is and where i would place this syntax.

       

      Thanks in advance for your help.

       

      Sunil