renaming dimension

[rcorcoran]

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()))

[tresB]

=If(Discharges=3, 'Bed Days', If(Discharges=5, 'Impatient' , Discharges))

[#3]

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

[tresB · Accepted solution]

I notice now, that you might not need other discharges, then :

=If(Discharges=3, 'Bed Days', If(Discharges=5, 'Impatient' , null()))

[MayilVahanan]

Hi

Try like this

Pick(Match(Discharges, 3, 5), 'Bed Days', 'Impatient')

[rcorcoran]

thanks tresesco that works great

Rhona