jnordstrand Posted August 11, 2014 Report Share Posted August 11, 2014 Can someone help me to Add the "Yes" Values in a report page. I need to be able to come up with a total of Yes selections in a Tabular Report. Thank you Quote Link to comment Share on other sites More sharing options...
0 Jan Posted August 12, 2014 Report Share Posted August 12, 2014 Hello jnordstrand, If I understand correctly, you have a table with fields that has DataTypes "Yes/No", and you want to aggregate how many fields has the "Yes" value. In this case, you can add a Calculated field, enter the code like CASE WHEN [@field:yes_no]='True' THEN 1 ELSE 0 END And add the aggregate by this field with Formula SUM. Quote Link to comment Share on other sites More sharing options...
0 roattw Posted October 17, 2017 Report Share Posted October 17, 2017 How would this work for counting non binary Yes/No field like a drop down, with 4 options? Thanks! Quote Link to comment Share on other sites More sharing options...
Question
jnordstrand
Can someone help me to Add the "Yes" Values in a report page. I need to be able to come up with a total of Yes selections in a Tabular Report.
Thank you
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.