9 Replies Latest reply: Jun 15, 2011 10:20 AM by Sridhar Ethiraj RSS

    set analysis exclude based on records in field

      Hi all

       

      I am trying to sum a column but would like to do this only where it does not equal 'No: addendum' in another field. The total seems to work ok however it does not seem to display properly in the charts.

       

      Sum({ $ - <IncludeMasterImagingTable={'No: Addendum'}>} [No of exams])

       

      Any help would be much appreciated.

       

      Thanks

       

      Dan