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