Expressions query

[#1]

I have the script below which provides me with:

• a sum of costs for Acute within the Quadrant field and
• a sum of costs for In Patients etc... within the Quadrant Sub category, where the Quadrant is Mental Health

=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

[Gysbert_Wassenaar · Accepted solution]

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 £]))

[#3]

Thank you, worked perfectly!