Calculations over Repeating Groups

Hi Ann,

A $total prompt with a calculate of $sum1+$sum2+$sum3 will give you
the sum inside the repeat. Then outside the repeat, sum($total) will
give you the sum of all the $totals.

Try it with a very small form and see how that goes.

Yaw

··· -- Need ODK consultants? https://nafundi.com provides form design, server setup, in-field training, and software development for ODK.

On Wed, Oct 28, 2015 at 4:53 PM, Ann D ann@theihanganeproject.com wrote:

I'm new to XLSForms and was wondering if any could help me. I am looking to sum up a group of 20 repeating questions (there's no constraint on how many times it could be repeated). I need it to sum up each time and then also the sum total. In the example below, let's say that the group of 4 questions was repeated 3 times. I need the individual scores each time as well as the total sum after it was repeated 3 times.

SUM001- 8
SUM002- 2
SUM003- 8
TOTAL_SUM001- 18

EXAMPLE

Q1. Does the scale hang on an immobile platform?

Yes - 2 points
No - 0 points

Q2. Is the scale calibrated to 0 including weight of harness?

Yes - 2 points
No - 0 points

Q3 Is heavy clothing removed before weight was taken?

Yes - 2 points
No - 0 points

Q4. Is the infant seated correctly in the harness (one arm situated in front of one harness strap and the other behind the opposite strap or in some way balanced in the harness)?

Yes - 2 points
No - 0 points

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.