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!