5 Replies Latest reply: Oct 19, 2012 2:57 PM by Jeremy Boyer RSS

    Want to create a filter based on a calculated expression

    Jeremy Boyer

      I have a table that is counting the number of visits, prescriptions and readmitions for each patient.  So the column will read

      Patient     |     Visits     |     Scripts     |     Readmits

      John Doe  |     10          |     4             |     1

       

      I want to be able to create filters that would allow me to limit my data to members with:

      • >= 5 Visits
      • >=10 Scripts
      • >= 2 Readmits
      • etc

       

      When I try to enter a formula into the selection box it gets grayed out and doesn't work

      if(sum({<CostService={'Primary Care'}>} Current_Util)>4,'Yes','No')

       

      Any thoughts?