2 Replies Latest reply on Oct 14, 2013 8:31 AM by juliette.mccormack

    Filtering nulls and parameters

    juliette.mccormack

      Hi all.

       

      Attached is a workbook showing an extract of some psychological therapies data.  I am trying to show for each completed referral whether a person's Score has increased or reduced.  For each completed referral it takes the first score for the person and the last score which is not necessarily the first and last appointment as scores are not taken every time.

       

      There are 10 or so different scores and I would like to be able to select the type of score to analyse (parameter Select Score) and this adjusts the chart based on the selection.  Managed to get it all working apart from one bit - typical!

       

      The problem is that I haven't been able to work out how to make my filter which excludes nulls to be based on the parameter selection.  I have tried creating a calculated field based on a CASE statement referring to my parameter but I get a Boolean error.

       

      Any help greatly appreciated.

       

      Many thanks.

       

      Juliette