I have created a form with many topics and then questions. Each topic has several questions, each question has 3 answers (Yes,No,N/A). Each Topic has its own Horizontal Repeating table with Buttons. I am able to sum all repeating tables as a whole but I can't figure out how to sum each user added Column independent of the entire table. For example I wrote an equation:
count(field1[.=1]) + count(field2[.=1]) + etc.
This will count all the 1's or Yes' in repeating table. Which is good but I also need it to count each column seperately. With a repeating table, when a user adds a column do the field names stay the same or are they different for example field1a or field2a. Without different field names for user added columns how can you count and sum them independently?