How do I count items in a list that meet a condition that are in a repeating group?
I have a repeating group that has all jobs. Each job has a list of tasks. I want to show a count of how many tasks each job has (works ok) and also how many are completed tasks (can’t get it to work).
Job one has 10 tasks 2 are completed
Job two has 12 tasks 4 are completed
I can get the total # of tasked but I am having a heck of time figuring out how to filter just the completed task that have in a is_completed (yes/no) field.
This part works:
This part gives me the number of tasks
I have Search Job’s Tasks: count (where search is type jobs and jobs ID = currents cell job’s unique ID
This part does not works:
However I can’t figure out how to filter the same results of tasks that are is_completed=yes