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...
0 imJihyo Posted September 5 Report Share Posted September 5 Hi! You can apply the same calculation provided above. Assuming you will only get the sum of one value at a time, you just need to change the condition and field names 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
3 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.