wsharba / opendatakit

Automatically exported from code.google.com/p/opendatakit
0 stars 1 forks source link

Calculating sum of values when selected yes value #1064

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
I am using excel to design odk form

I need to calculate sum of values that are assigned to each question when yes 
is selected.

if a person has suffered throat infection and select yes, he is assigned with 
value 1.27. now for more than 3 variables i need to calculate the total score 
when is yes but when no it will be 0 value to each and the calculation can give 
the total as well.

Help me with the formula of the means i can do this arithmnetic.

Original issue reported on code.google.com by deoti...@gmail.com on 16 Sep 2014 at 12:07

GoogleCodeExporter commented 9 years ago
Thinking of adding default integer values that can be used when yes is selected 
to calculate the sum of those yes values

Original comment by deoti...@gmail.com on 17 Sep 2014 at 8:30

GoogleCodeExporter commented 9 years ago
I believe this was addressed on the opendatakit@ list. Closing.

Original comment by mitchellsundt@gmail.com on 17 Nov 2014 at 7:20