2 Replies Latest reply: Dec 14, 2015 11:02 AM by Sunny Talwar RSS

    how to use count with multiple criteria

      I am trying to perform a ratio calculation that requires multiple criteria.  I am trying to get the percentage of orders that meet 2 criteria (visit column has a "1" AND Revisit column has "0").  I used a comma to separate the criteria at first but it doesn't seem to give the correct answer.  Is it correct that a comma would separate multiple criteria? Any ideas on what I may be doing wrong?

       

      Thanks!