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:




      On Hold


      A table box containing the following columns:



      Start Date

      Finish Date


      % 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.