2 Replies Latest reply: Dec 4, 2012 9:21 AM by Claire Jenkins RSS

    Expressions query

      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