4 Replies Latest reply: Sep 2, 2010 7:59 AM by JASON TROFIMCZUK RSS

    set analysis not working

      hi, im trying to add set analysis to an expression so that it sums 'IPTotal' for all 'Weeks' and where IPType = 'Daycase' and any values that dont match as null.

      The expression that was used previously was:

      Sum(if(IPType='Daycase',IPTotal,null()))

      But the problem with this expression is that it didnt use set analysis to show all 'Weeks'

      The expression i created to include set analysis is:

      SUM({$<IPType = {'Daycase'},Week = {'*'}>} IPTotal)

      But now the problem with my set analysis attempt is that this expression correctly shows all weeks but incorrectly doesnt show any data for IPTotal.

      Please see image below:

      error loading image

      Any Ideas?