Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
I have this expression below in a dimension of a straight table to limit the data it brings back. It works fine but I also want to rename the 3 and 5 to show bed days for Discharges=3 and inpatient for 5 in the chart. Any help??
thanks
=(if(Discharges='3' or Discharges='5',Discharges,Null()))
I notice now, that you might not need other discharges, then :
=If(Discharges=3, 'Bed Days', If(Discharges=5, 'Impatient' , null()))
=If(Discharges=3, 'Bed Days', If(Discharges=5, 'Impatient' , Discharges))
Hi Rhona,
=if(Discharges='3' , Discharges,
if (Discharges='5', Inpatient,
Null()
) )
Here is what i understood
or may be you want to modify 3 and 5, you can use variables
best regards
Chris
I notice now, that you might not need other discharges, then :
=If(Discharges=3, 'Bed Days', If(Discharges=5, 'Impatient' , null()))
Hi
Try like this
Pick(Match(Discharges, 3, 5), 'Bed Days', 'Impatient')
thanks tresesco that works great
Rhona