how to use count with multiple criteria

[#1]

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!

[igdrazil]

Hi Sam,

It would look somewhat like this:

sum( {$<Visit = {'1'}, Revisit = {'0'}>} counter).

Hope this helps, good luck!

Regards

Chris

[sunny_talwar · Accepted solution]

Not sure what you have already tried, but may be this:

Count(DISTINCT {<Visit = {1}, Revisit = {0}>} Orders)