Skip to Content
0
Jan 02, 2020 at 04:32 PM

Writing variables containing Max and ForEach

306 Views Last edit Jan 02, 2020 at 04:34 PM 2 rev

Webi Environment: SAP BusinessObjects BI Platform 4.2 Support Pack 3 Patch 6

I'm looking to create two variables associated with each patient number; one for the most recent recon performed date/time and one for the order recon status associated with the most recent date time. I will then add the two variables to my main query as detail variables.

For example, Margaret has two entries. I would want to identify the max order recon ID, then take the order recon status and recon performed date associated with that line: Complete and 12/19/2019 08:27:52 AM

Can anyone assist with writing the formulas needed to make this work? I've tried it a number of ways with ForEach or In along with the Max, but no luck so far. Thank you in advance!

data-set.jp
max-order-recon-id.jpg

Attachments

data-set.jpg (62.1 kB)