Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the script below which provides me with:
=money(Sum({1<Quadrant={"Acute"}>+1<Quadrant={"Mental Health"}, [Quadrant Sub category]=
{"In Patients","Day Care", "Out Patients Procedures", "Outpatients East", "Outpatients West"}>} [Cost £]))
I'm looking to develop this, to say the above, but when the field "Episodes" is not blank
I would appreciate your advice on this
Many thanks
Claire
Is this what you need?
=money(Sum({1<Quadrant={"Acute"},Episodes={"=len(trim(Episodes))>0"}>+1<Quadrant={"Mental Health"},Episodes={"=len(trim(Episodes))>0"}, [Quadrant Sub category]=
{"In Patients","Day Care", "Out Patients Procedures", "Outpatients East", "Outpatients West"}>} [Cost £]))
Is this what you need?
=money(Sum({1<Quadrant={"Acute"},Episodes={"=len(trim(Episodes))>0"}>+1<Quadrant={"Mental Health"},Episodes={"=len(trim(Episodes))>0"}, [Quadrant Sub category]=
{"In Patients","Day Care", "Out Patients Procedures", "Outpatients East", "Outpatients West"}>} [Cost £]))
Thank you, worked perfectly!