1 Reply Latest reply: Dec 15, 2011 9:31 AM by Martina Brenner RSS

    Adding calculations to Multi Boxes for selection

    Jeremy Boyer

      I have a column in a table that is calculated using the following logic:

      count({$<VISIT_TYPE={'ER'}>} DISTINCT VISITNUMBER)

       

      I want to add a selection item to my Mulit box that says:
      if(count({$<VISIT_TYPE={'ER'}>} DISTINCT VISITNUMBER)>'0','Yes','No')

       

      This will allow the user to filter on all records where the visit count is greater than 0. QV doesn't like the calculation in the Mulit box and grays out the selections.

       

      Thanks!