7 Replies Latest reply: Jan 7, 2018 7:09 AM by Luis Madriz RSS

    count (distinct if . . . . . .

    Celia Seward

      Hello All.

       

      This works for me:

       

      count(distinct if (DC>0,studentid))    - count students who received direct or consult services

       

      and this works too:

       

      count(  distinct if ( (Ref>0) ,studentid  ))  - count students who were screened or evaluated

       

      BUT, this does NOT work:


      count(  distinct if ( (Ref>0) and (DC>0) ,studentid  ))  -  count students who were screened or evaluated and who received direct or consult services;  this expression always returns a ZERO