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.
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
Thanks Mike, I see that now
Appreciate it
Justin
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?
Bringing this up since I came up with the solution to this.
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
Which would just be the number of items in “Org Departments” in this example.
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.
Hope this helps others!
Nice information, the community are really great
