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

How to add multiple variables to an expression?

haagenfels

Hi,

 

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,

Nicholas