15 Replies Latest reply: Oct 2, 2012 4:59 PM by satyajeet29 RSS

    How to add multiple variables to an expression?



      I am trying to create a chart that shows the count of "Yes" and "No" from our data.  I have two column legal validated (Yes/No) and Comp Validated (Yes/No).  How can I get the count of No/No, Yes/No, No/Yes, all under the same count as 'No'? And then show a count of all the 'Yes/Yes"?   


      I was able to get a count of the Yes and No using this equation;


      Dual(CompValidation&' - '&Count(DISTINCT([Topic),Count(DISTINCT(Topic)))


      Thank you,