How do I count only certain rows in a repeating group

Questions
1

I have a yes/no toggle for each row in my repeating group. I need to count only those rows where the toggle is “yes”. I can’t seem to limit the count for some reason. I’ve tried filtering and the code in the screenshot below to no avail.

I’ve check all over in the forums but haven’t been able to find the solution. Seems like it should be simple. Alas.

Screen Shot 2020-08-03 at 3.29.31 PM

2

You can’t access the RG’s innards like that. As covered here:

3

Okay. Thanks for your reply. Seem like I should be able to query the data table somehow though and count the “yes” items from there (?)

4

Hi there, @john24… you should be able to do what you just described… do a search for Experiences with a constraint on the search where ExpTop = yes and add :count to the end of the search. Have you given that a shot?

Best…
Mike

5

Thanks! I tried so many different angles and then you came through and tipped it in. Here’s what worked:
Screen Shot 2020-08-03 at 4.35.56 PM