I've asked this question in one manner, and not found a solution yet, so lets try a different tack 😂
I have a table that appears similar to below:
And i'd like to be able to create a table that only shows the referrals to a non-Urgent Service, where the UserID has also had contact with an Urgent Service, and where the Contact_Date for that Urgent Service is after the RefDate of the referral of the non-Urgent Service.
So based on the above table it would show:
This is a simple version of my actual tables, what i'm essentially trying to do is using p() create a couple of datasets, then intersect them, and then perform =if()'s on the resulting table.
Where I'm running into issues is the limitation on one expression within the p(), adding any other set analysis treats the additions as an 'OR'.