Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am using this set analysis which is working perfectly fine -
=count({<Referral_Number = p({<[ServiceContact_K10+_ ServiceContact_ReasonForCollection]={"Episode start"}>})* p({<[ServiceContact_K10+_ ServiceContact_ReasonForCollection]={"Episode end"},Calendar ='Referral_End_Date',Referral_CompletionStatus-={"Episode Open"}>}) >}distinct Referral_Number)
I need to add - Calendar ='Referral_End_Date' to the set analysis but can not get it to work
Any ideas?
Thank you