Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here




Good afternoon, I've been searching all morning to no effect. We need to identify patients who are admitted to hospital from a Care/Residential home. We have a workbook that lists all the care homes in our area; name; address1 etc. & postcode. I have used this as a source for a second query in the report. We want to match these up to any patient and have to use the postcode as there may well be discrepancies between the spelling of the actual home's name and how it is recorded, but the postcode is always just that.

To this end I have created a Detail Variable that uses the postcode merged dimension:
Care Home Current Inpatients
=If ([Current Inpatients].[Postcode]= [Care Homes].[Postcode]) Then [Care Home Name]

It just so happens that there is more than one Care Home in certain postcodes, so I don't have a 1-to-1 relationship and get "#MULTIVALUE". I've tried:
MAX - this shows me the last Care Home relevant to records within that particular block
MIN - this shows me the first Care Home relevant to records within that particular block

B = [Care Home Current Inpatients] ForEach([Current Inpatients].[MRN- Organization]) - this still shows #Multivalue

Object 1 = [Care Home Name]+" , "+Previous(Self) - this just adds commas to each row, increasing by 1 each time

Object 2 =[Object 1] Where ([Care Home Name]=[Maximum]) - this just displays #CONTEXT next to all the commas

I'm stumped :(

If anyone can crack this I'd be extremely grateful!

Many thanks,

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close