• 0
nuimage

How to tally ye/no responses.

Question

Hello All,

I have  a simple form asking users to check the "Yes" checkbox if they prefer a vegetarian meal option.  The field datatype is "Yes/No".   I have a report that i would like to count only those who checked "Yes".  I've created an aggregate field in the report called "Veg Count" and I have selected the field "veg" to do a count function on.  However, i'm unable to count only those who have checked the checkbox.   It gives me a tally of all entries "yes" and "no".

How can i count only those boxes that have been checked and has a value of "Yes".   I cannot figure out how to create such a report.  Any help would be greatly appreciated!

 

Share this post


Link to post
Share on other sites

6 answers to this question

  • 0

Hello NUIMAGE,

 

You will still need to use the total and aggregation, but instead of function, you need to choose formula and use a simple SQL statement. Please see sample screenshot below with the SQL code. Please change YesNo with your own field and test_table with your table name in where you want to COUNT.

image.png.7059bcb71bbcb8eaf02b0c948ae8f9f9.png

 

yours truly,

Franchiser

Share this post


Link to post
Share on other sites
  • 0

Franchiser,

Thank you! Thank you! for such a quick response.   Initially,  i tried a select statement but instead of a value of "1",  i indicated a value of "yes".   I completely forgot that Yes/No fields have numerical  values of  "1" or "2".    Your solution worked like a charm.

Thanks again, you are a life saver.

 

nuimage

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now