Guide: Calculation Questions on Collect

Simplify your data collection using calculation questions. They can help you do addition, subtraction, and other operations in real time.

Collect supports a variety of calculation questions to help you make your data collection easier and error-free. If you need to get some calculated results in your form, whether it is as simple as age (based on date of birth) and total students (based on girls and boys in a school), a custom expression, or something more complex like a Z-score, you can do anything using calculation questions.

In this article, we will discuss the kinds of calculation questions and when to use them.

Kinds of Calculation Questions

  • Addition: Use this to get the sum of two or more number questions in your survey form.
  • Subtraction: Use this to get the difference of two or more number questions in your survey form.
  • Multiplication: Use this to multiply two or more number questions in your survey form.
  • Ratio: Use this to get the ratio two number questions in your survey form.
  • Percentage: Use this to get the percentage of one number question against another number question in your survey form.
  • Date Difference: Use this to get the difference between two date questions in your survey form.

Creating Calculation Questions

Type A. Addition

We will take an example where you are running a school inspection survey. As a part of this survey, you go to a school and ask for:

a. The number of boys

b. The number of girls

Now, you also want the total number of students in the school. Instead of asking for total students or manually adding the number of boys and girls, you can simply add an addition question — add the number of boys and the number of girls. Check the image below to see what it looks like.

Note: You can add more than two questions as well.

screely-1546503076826

Type B. Subtraction

Imagine you are running a store where you record stock in and stock sold everyday. Now, at the end of the day, you want to know how much stock is left and can be used the next day. For this, instead of asking your store manager to manually count or calculate, you can add a subtraction question — subtract sold stock from total stock in. Check the image below to see what it looks like.

Note: You can subtract more than two questions as well.

screely-1546503762575

Type C. Multiplication

Imagine you are running a property audit to find potential store locations. As a part of this audit, you want to calculate the area of the square plots being audited. Now, instead of remembering the area formula and manually multiplying, you can add a multiplication question — to do side*side to get the area of these square plots. Check the image below to see what it looks like.

Note: You can multiply more than two questions as well.

screely-1546504027526

Type D. Ratio

We will take an example where you are running a school inspection survey. As a part of this survey, you go to a school and ask for:

a. The number of boys

b. The number of girls

Now, you also want the ratio of girls to the boys in the school. Instead of asking for the ratio or manually calculating the ratio (possibly with errors), you can simply add a ratio question — to get the ratio of girls to boys in every school. Check the image below to see what it looks like.

screely-1546504234097


Type E. Percentage

Following the same example we took above, you can further go and find the percentage of girls in schools. For this you can add a percentage question on Collect — percentage of girls against the total students in the school. Check the image below to see what it looks like.

screely-1546504403712

Type F. Date Difference

Imagine you are running a vaccination camp in a village to improve the health standards of children. In many cases, parents get delayed in their scheduled vaccination.

If the delay is less than 13 days, you can give the scheduled vaccination. Otherwise, you have to give a heavier dose and follow different protocols. Now, instead of spending time in manually calculating the delay and finding the difference between the scheduled date and actual date of visit, you can add a date difference question — to find the difference between the two dates. This will save a ton of time when you already have a time crunch and multiple patients to tend to.

Check the image below to see what it looks like.

screely-1546504718444

Note:

In addition to calculation questions, Collect supports 27 other question types like image, location, signature, etc. You can read more about them in this detailed guide.

Help and Support:

Need any help or have some questions? Just drop us an email at support@socialcops.com and we will get right back!