Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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'.
Could you share a sample data.