I want to be able to return a count of how many times a certian choice has been selected in a repeating section. There is a choice field which is a simple "Yes" or "No" option. I want to count how many times "Yes" has been selected and return that value.
E.g. there's 15 rows in a repeating section, and "Yes" has been selected on 10 of the rows. I want the value 10 to be calculated and displayed.
Solved! Go to Solution.
While not exact, you can use Vadim Tabakman's solution to parse through your repeating section. See his post here:
You can then just add in a run if statement that will add a number to each instance equals "Yes". Download his user defined action and workflow. At this point, I do not see a way to do this in the form itself. It will most likely have to be performed via a workflow.
I agree with @mlauer that yes/no controls would be more suitable in this scenario.
they even wouldn't needed any extra calculation - their true/false values are automatically treated as 1/0 in numeric formulas. so you could directly sum/count over them.