1 Reply Latest reply: Oct 8, 2012 2:07 PM by whiteline _ RSS

    Suppress Nulls In Expression

    Helen Pippard

      Hello

       

      I have the following code in my expression of a pivot table:

       

       

      =

      If(ValueList('Total Treatment Time', 'To Initial Treatment', 'Left Without Being Seen') = 'Total Treatment Time' and ValueList('Admitted', 'Non Admitted','') = 'Admitted', Median([Total Wait])/1440,
      If(ValueList('Total Treatment Time', 'To Initial Treatment', 'Left Without Being Seen') = 'Total Treatment Time' and ValueList('Admitted', 'Non Admitted','') = 'Non Admitted', Median([Total Wait])/1440,
      If(ValueList('Total Treatment Time', 'To Initial Treatment', 'Left Without Being Seen') = 'To Initial Treatment' AND ValueList('Admitted', 'Non Admitted','') = '', Median([Total Wait]

      )/1440)))


      I have searched this forum and it is suggested that set analysis will get rid of any nulls

       

      Could you kindly help me write the set analysis for

      Median([Total Wait])/1440

      ?

       

      Kind Regards

      Helen