This content has been marked as final. Show 2 replies
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?