Creating Complex Calculations Using Single Set of Brackets
Another one of the calculation features is grouping or using brackets to apply conditions to a certain set of questions.
On this page we will review how to use one group/set of brackets in a calculation, and on the next page we’ll explore how to use multiple groups/sets of brackets.
Let’s explore this through the example below:
In this example, we are looking at a question that has asked a group of respondents about their level of confidence in certain topics they have been trained in. The indicator we are analyzing asks us to find out how many of the respondents are “Very Confident” or “Somewhat Confident” in at least 3 of the 5 topics.
1. To start, we added all of the questions needed for this calculation into the “Calculate results for” section. Then selected “Very Confident” and “Somewhat Confident” as the two responses we want to calculate and selected “Save”.

2. We clicked on the square button to the left of the questions (pictured below) to add the bracket:

3. We dragged the bracket around all the questions we want to group together:

4. Now we can see that we have created a group because there is a box appearing around all of the questions:

5. Now we can add an “At least” or “At most” condition for this group, by selecting the pencil button in the top right corner of the box:

6. Our indicator is “Percentage (#/total) of participants confident in their skills in permaculture” and the indicator detail tells us that we want to calculate “Participants that answered 3 out of 5 permaculture-related confidence questions as “Very confident” or “Somewhat confident””. Therefore we choose to use the “At least” function and select “3” then click on the check-mark to save this condition:

7. Now we have created a group where at least 3 of the 5 questions have to be answered in the specified way:

8. Finally, we can select “Calculate indicator” and see the calculation for this indicator in the Results:

Next, let’s explore how to use multiple groups/sets of brackets to set up a calculation.
How to Create Complex Calculations Using Multiple Sets of Brackets
Now that you know how to use brackets, let’s quickly review an example where you create multiple groups with brackets in your calculation.
In this example we want to filter for a sub-set of respondents from our survey. We want to look at only Male respondents who are less than or equal to 20 years of age, OR, Female respondents who are less than or equal to 25 years of age.
1. As we reviewed on the last page, you want to select the relevant questions and place them in the “Filter results by” section. And select the relevant question responses (e.g. Male) and select “Save”. Then you will use the bracket tool to create two groups: one for Males <=20 and one for Females <=25.

2. Then we select the relevant operator between the two groups, in this case we chose the “OR” operator:
