# Issue with :count on data that is yes/no

**URL:** <https://forum.bubble.io/t/issue-with-count-on-data-that-is-yes-no/228877>\
**Category:** Database\
**Created:** [October 18, 2022, 5:36pm UTC](https://forum.bubble.io/t/issue-with-count-on-data-that-is-yes-no/228877 "2022-10-18T17:36:57Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![jcjags63](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jcjags63/32/152820_2.png) [@jcjags63](https://forum.bubble.io/u/jcjags63)\
**Post date:** [October 18, 2022, 5:36pm UTC](https://forum.bubble.io/t/issue-with-count-on-data-that-is-yes-no/228877/1 "2022-10-18T17:36:57Z")

</div>

Hi I am having trouble with a list of items in my databse which are yes/no. I am trying to find the count of items that are “yes” and return a result of false if the total count of items does not equal to the number of items that are yes:count.

You can see below that there are 4 items, 2 yes, 2 no. It should result in a :count of 2 but I don’t see what is wrong.

![Screenshot 2022-10-18 133443](https://us1.discourse-cdn.com/bubble/original/3X/e/4/e498c9323c18fbe562d6ab136e3215f2e435adb8.png)  
 ![Screenshot 2022-10-18 133501](https://us1.discourse-cdn.com/bubble/original/3X/b/3/b3067c65ca6792b79b11a871ddf6b744b2fc6c0b.png)

---

<div class="post-metadata">

**Author:** ![mikeloc](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/mikeloc/32/93001_2.png) [@mikeloc](https://forum.bubble.io/u/mikeloc)\
**Post date:** [October 18, 2022, 5:50pm UTC](https://forum.bubble.io/t/issue-with-count-on-data-that-is-yes-no/228877/2 "2022-10-18T17:50:38Z")

</div>

Hi there, @jcjags63… for the second part of the expression, try `Current Page Pick List's order items:filtered:count`, and add a constraint to the filter where `pick_complete = yes`.

Best…  
Mike

---

<div class="post-metadata">

**Author:** ![jcjags63](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jcjags63/32/152820_2.png) [@jcjags63](https://forum.bubble.io/u/jcjags63)\
**Post date:** [October 18, 2022, 5:51pm UTC](https://forum.bubble.io/t/issue-with-count-on-data-that-is-yes-no/228877/3 "2022-10-18T17:51:29Z")

</div>

Thanks Mike, I see that now

Appreciate it  
Justin

---

<div class="post-metadata">

**Author:** ![paul29](https://avatars.discourse-cdn.com/v4/letter/p/5f8ce5/32.png) [@paul29](https://forum.bubble.io/u/paul29)\
**Post date:** [October 18, 2022, 5:52pm UTC](https://forum.bubble.io/t/issue-with-count-on-data-that-is-yes-no/228877/4 "2022-10-18T17:52:19Z")

</div>

Without testing this myself, I believe you need to turn on the bubble beta feature for parentheses in the versions tab in settings.  
I think you ahve an order of operations issue. Can you send screenshots of the evaluator of each of the elements in your expression?

---

<div class="post-metadata">

**Author:** ![ihsanzainal84](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ihsanzainal84/32/245932_2.png) [@ihsanzainal84](https://forum.bubble.io/u/ihsanzainal84)\
**Post date:** [October 14, 2025, 4:25am UTC](https://forum.bubble.io/t/issue-with-count-on-data-that-is-yes-no/228877/5 "2025-10-14T04:25:58Z")

</div>

Bringing this up since I came up with the solution to this.

## Problem

![image](https://us1.discourse-cdn.com/bubble/original/3X/6/0/60f8c3b9f2bc38b8c46a38241eed48ce15d107da.png)

This expression results in a list of “yes/no”, so adding a :count operator just counts the number of items in those list. Hence results in true since there are items in the list

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/0/a/0aaa304682b269831c5371fb657ab16137c45bac.png)

Which would just be the number of items in “Org Departments” in this example.

## Workaround

![image](https://us1.discourse-cdn.com/bubble/original/3X/6/1/6130951f5a5460d3284c9a3af81a8d73932fbd3c.png)  
Using :formatted as number will give me a 1 for matches. I then sum and compare it to how many matches I want (in this case I just need a single match).

The sum returns 1 and this will work correctly as seen below.

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/a/5/a529199ec6562a248832c064c4e2a64e51a078c0.png)

Hope this helps others!

---

<div class="post-metadata">

**Author:** ![robertsoker62](https://avatars.discourse-cdn.com/v4/letter/r/48db29/32.png) [@robertsoker62](https://forum.bubble.io/u/robertsoker62)\
**Post date:** [October 14, 2025, 8:39am UTC](https://forum.bubble.io/t/issue-with-count-on-data-that-is-yes-no/228877/6 "2025-10-14T08:39:07Z")

</div>

Nice information, the community are really great