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
